A simple if statement I cant get to work

[chally3]

Hi all,



Can anyone help with a simple query please as I’m just stuck as this should be a simply if statement



Column R1 = a number field

Column S1 = blank or date

Column T1 = Is where I wish the data to go and is a date column



Ie in cell T1:-- if S1 is null to add R1 to today’s date (as in the formula to get todays date), if S1 is not NULL calculate S1+R1





Thank you

 

[Joe4]

Try:

=R1 + IF(S1="",TODAY(),S1)

 

[chally3]

perfect, Than you! So quick!

 

[Joe4]

You are welcome.
Glad I was able to help!