Except

[stevenal]

Have searched your boards and been unable to find what I am after. I have a spreadsheet which calculates from entries in date columns whether something was completed on time etc:

=IF(ISBLANK(RC[-2]),IF(RC[-3]>NOW(),"Within Timeframe","Overdue"),IF(RC[-2]>RC[-3],"Finalised Late","Finalised On Time"))

RC[-2] and RC[-3] are dates

But I only want this result IF another cell in the row is NOT blank - this cell contains information about what is supposed to be done by the due date and if there is a blank it means there is no action due and therefore cannot be overdue
I tried adding another IF but because of the maximum of 3 I couldn't add it

This is a spreadsheet I have inherited and the original formula was not mine - I've learnt lots from playing around with it and this is the only problem I have left

Help ...

 

[xenou]

Hi,
I am not aware of a limit of three IF's.
This *should* work:
=IF(ISBLANK(X),"Y",IF(ISBLANK(RC[-2]),IF(RC[-3]>NOW(),"Within Timeframe","Overdue"),IF(RC[-2]>RC[-3],"Finalised Late","Finalised On Time")))

Where X is the other cell, and Y is the value you want to show if it is blank.

 

[stevenal]

Wow - thank you so much - that works - and now I am a better Excelist