I need to combine an "if" formula & an "and" formula, pls help ;)
 

I'm using this formula =IF(H12F12,"Overdue","On Time"), but I also want to
include if H12 is blank, then leave my cell (delivery status) blank. I
rather have nothing in the cell than "on time". And also, I want to include
if it's overdue, can I color code it red. Are these requests possible?

Thanks,
Tiffany

I need to combine an "if" formula & an "and" formula, pls help ;)
 

TPurdy wrote:
I'm using this formula =IF(H12F12,"Overdue","On Time"), but I also want to
include if H12 is blank, then leave my cell (delivery status) blank. I
rather have nothing in the cell than "on time".

=if(H12="", "", if(H12F12, "Overdue", "On Time"))

And also, I want to include
if it's overdue, can I color code it red.

Click Format Conditional Formatting. In the three fields, select
Cell Value Is, Equal To, and ="overdue". In the same menu, click
Format... and select Color: Red.