View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
TPurdy TPurdy is offline
external usenet poster
 
Posts: 1
Default 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