IF statement

[orion1951]

Hi,
I have the following formula in an excel cell - =IF(S80<>"",(S80)+41,"")
This puts a date in in the cell that is 41 days later than the entry in cell 80 if it isn't blank.
What I would like to do is if cell Y80 has an entry then the target cell will be blank. I've tried to do 2 IF statements but can't seem to get it to work?.

thx,

John

 

[Special-K99]

Remove the brackets around S80, you don't need them

Do you mean this, it's not clear.

=IF(Y80<>"","",IF(S80<>"",S80+41,""))