need formula
I need a formula to do the following
("Cell contents"-60)*2
("Cell contents"-80)*6
("Cell contents"-90)*2
Cell contents in each case is same cell so only want line 2 to apply only if
contents greater than 80 and line 3 if contents only greater than 90 other
wise answer could be a negative amount
anyone understand what I mean and got an answer
thanks if you have
|