| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
2 conditions for IF function?
Hi -
I want to use a function to display a value in a cell if it meets 2 conditions Condition 1) That there is data entered in cell T10 and if no data return a blank in the cell Condition 2) That the number in cell AO10 is <16 so I basically want to combine =IF(T10,T10,"") and =IF (AO10<16,T10,""). I have tried AND but with no joy - sorry this is baffling me!! Thanks for your help Paul |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| conditions and the max function | Excel Worksheet Functions | |||
| How to use the IF Function for 3 conditions | Excel Worksheet Functions | |||
| Max function with conditions | Excel Worksheet Functions | |||
| If Function - two conditions? | Excel Discussion (Misc queries) | |||
| If function with more than 7 conditions | Excel Worksheet Functions | |||
Threaded Mode
