trevor3007

hi, Any one have the formula so if a cell > 0, then that cell -30 but if that cell is empty dont display anything? I know if I used =if(a1>0,a1,"") that works, but when I add the -30 it either displays -30 or #value can someone sort me out? KR Trevor3007

hi, Does anyone have the magic formula for this critera/issue:- if the date in a2 does not match the date in a2, then a2 many thanks in advance... KR Trevor3007

hi, i need to create a input box so when the user puts the text into, it will place the text in d1 on sheet 2 I am able to do the above only on sheet 1 . Can anyone help? KR Trevor3007

Hi, I use the the code below:- =IF(G2="y",TEXT(TODAY(),"dd/mm/yyyy"),"") which work great until the next day, when yesterdays day is now the present day. Is there a way to retain the original date ? Many thanks in advance. KR Trevor3007

hi, I need to set a criteria so if A1>0 and c1="control" then e1 =1 Thinking it would be:- =if(a1>0,and(c1="control",1,"")) but that does not work ;{ thank you for your help. Trevor3007

hi, Does any know how to add the subject line into email body, rather than copy & paste into ? Hoping someone can 'rescue me' & thank you for your help. KR Trevor3007