Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Simple if, if ?
I have 1's or 0's in row 3 , D E F G H I J
Col L sums D:J If the sum of D3:J3 does not = 5 (col L), I want an "alert" in K3, such as: =IF(L3<5,"Alert","") However, I also need it to additionally refer to another cell (C3) Something to the effect: If there is text in C3, (maybe C30 ??), and the above "Alert' would be in K3, then give me that ALERT, but, if there is nothing in C3, even if the "Alert' would be produced in K3 because of the above formula, I don't want the "Alert". I want nothing "". Thanks, Steve |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Simple lookup - or maybe not so simple - help! | Excel Worksheet Functions | |||
This has to be simple but...... | Excel Discussion (Misc queries) | |||
Help me with what seems simple | Excel Worksheet Functions | |||
Simple Simple Excel usage question | Excel Discussion (Misc queries) | |||
Make it more simple or intuitive to do simple things | Charts and Charting in Excel |