|
|
IFs and Calculation
If it is less than 25000 then it is zero; ELSE if less than 500K it is F64 times 11.5 div 1000; ELSE it is F64 times 11.5 div 1000 PLUS the remainder of F64 minus 500K times 8.5 div 1000
Just string a bunch of Ifs together but you are limited to 7 nested Ifs.
=IF(F64<25000,0,IF(F64<500000,(F64*11.5)/1000,((F64*11.5)/1000)+((F64-500000)*8.5)/1000))
©
2003-2008
| Updated: | 04/02/2008 19:33 |
| This page added: | 01 May 2003 |
|