| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If formula with two conditions to meet
I have the following scenario:
If the value in cell Z5 is equal or greater than "0" the person gets $700 AND if in addition field value in cell AB5 reflects a number equal or greater than "3" then person gets $700 + 300 for a total of $1000 How should I compose the IF formula on cell O5? Any help with be much appreciated. Thanks. Carolina |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Counting rows that meet conditions in multiple columns | Excel Worksheet Functions | |||
| count pieces of records meet conditions in different columns | Excel Worksheet Functions | |||
| Array to meet conditions | Excel Worksheet Functions | |||
| Hiding rows that meet multiple conditions in excel | Excel Discussion (Misc queries) | |||
| counting cells in a data range that meet 3 specific conditions | Excel Discussion (Misc queries) | |||
Threaded Mode
