Spreadsheet Formulas

css navigation by Css3Menu.com

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-2017

Updated:  04/06/2017 20:32
This page added:  01 May 2003