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.


© 2003-2017

Updated:  06/14/2017 17:53
This page added:  01 May 2003