| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
USE IF CONDITION FOR 2DATA
HI,
In excel sheet we have data like , A B C (Avg) (Month) (Result) 12 12 PLA 11 7 GOLD 6 5 SILVER formula need like, IF(A2=12,IF(B2<=12,"PLA",IF(A2=10,IF(B2<126,"GO LD", IF(A2=5,IF(B2<=6,"SILVER"))) PLS DO THE NEEDFUL REGARDS, DEEN |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Combine an OR condition with an AND condition | Excel Discussion (Misc queries) | |||
| How to use condition | Excel Discussion (Misc queries) | |||
| Max or Min with condition | Excel Worksheet Functions | |||
| Condition 1 overules condition 2? | Excel Worksheet Functions | |||
| How to set condition: A1=A2=A3= ... =A10 | Excel Worksheet Functions | |||
Threaded Mode
