IF statement

orion1951

New Member
Joined
Jul 8, 2019
Messages
3
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
 

Some videos you may like

Excel Facts

What does custom number format of ;;; mean?
Three semi-colons will hide the value in the cell. Although most people use white font instead.

Special-K99

Well-known Member
Joined
Nov 7, 2006
Messages
8,342
Remove the brackets around S80, you don't need them

Do you mean this, it's not clear.

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

Watch MrExcel Video

Forum statistics

Threads
1,099,362
Messages
5,468,180
Members
406,569
Latest member
Quest_

This Week's Hot Topics

Top