| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help with Conditional Formula
I'm trying to create a conditional formula like:
=IF(OR(F2="Change",F2="New")*AND(G2="Auto CU")*AND(Q2=1),150,IF(Q2=2,200)) It works; however, if F2 is blank it still puts in the results either for Q2=1 or Q2=2 How can I solve this. If there is no entry in F2 then I would want a "Blank" result passed. Many thanks for any help. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional Formatting Against a Formula - not it's result | Excel Discussion (Misc queries) | |||
| Conditional Sum Formula? | Excel Discussion (Misc queries) | |||
| need a conditional formula to generate numbers divisible by 4 between a given starting no. & end No. | Excel Worksheet Functions | |||
| Conditional formatting...cont. from 9/25 | Excel Discussion (Misc queries) | |||
| Formula Dependant Conditional Formatting | Excel Discussion (Misc queries) | |||
Threaded Mode
