IF Formula

[dunmore83]

Hi... firstly thanks so much for your help everyone! I have been posting lot's of questions & am so thankful for your assistance!

This scenario is;

- if cell I11 has a 'numerical value' then K3 needs to display "N/A"

- if cell I11 has "N/A" then K3 should return value in cell H3 (DAY 2) plus one day
i.e. value in K3 would be DAY 3

cheers

 

[Robert Mika]

Try this:

=IF(ISNUMBER(I11),NA(),IF(ISNA(I11),"DAY "&RIGHT(H3,1)+1,""))

 

[dunmore83]

THANKS BUT IT DIDN'T WORK

I HAVE SIMPLIFIED THE SCENARIO A LITTLE:

- IF CELL T4 CONTAINS THE TEXT "N/A" THEN CELL T3 SHOULD HAVE THE TEXT "N/A"

- IF CELL T4 CONTAINS A DATE (IN THIS FORMAT ddd dd-mmm-yy;@) THEN CELL T3 NEEDS TO BE CELL Q3 (WHICH IS DAY 5) + 1
I.E. CELL Q3 = DAY 5
CELL T3 = DAY 6

THANKS! HOPE IT MAKES SENSE!