| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
nesting if formula
=if(f6<56.16, f6*7.2,f6*7.9/2)
hi all the above formula calculates f6, when less it does the far calculation otherwise it performs the other,what i really want is for f6 to have 4 points of reference from f6< 40 multply x3 ,from30x5 ,from 20 multiply 6 ,from 10 multiply x7 any help please thanks john |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Nesting of more than 7 in an IF formula | Excel Worksheet Functions | |||
| Can you help nesting a formula? | Excel Worksheet Functions | |||
| NESTING FORMULA | Excel Worksheet Functions | |||
| Nesting Formula | Excel Discussion (Misc queries) | |||
| nesting another formula | Excel Worksheet Functions | |||
Threaded Mode
