| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
IF Dilema
My dilema is that in the same statement you read below, I have to also ask
also if T27.4 and dg193=1,2,3,4,or 5, but that would be too many IF statements. Any ideas on how to reduce this statement? =IF(AND(DG192=1,T2<7.5),C3,IF(AND(DG192=2,T2<7.5), C4,IF(AND(DG192=3,T2<7.5),C5,IF(AND(DG192=4,T2<7.5 ),C6,IF(AND(DG192=5,T2<7.5),C7))))) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| sorting dilema | Excel Discussion (Misc queries) | |||
Threaded Mode
