| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Combine logical formulas "if", "and", "or" | Excel Discussion (Misc queries) | |||
| Reusing formula | Excel Discussion (Misc queries) | |||
| Dynamic Range with unused formula messing up x axis on dynamic graph | Charts and Charting in Excel | |||
| How do I combine the 4 IF formulas into 1 formula | Excel Worksheet Functions | |||
| formula to combine cells using if/then | Excel Worksheet Functions | |||
Linear Mode
