Thread: need formula
View Single Post
  #1   Report Post  
jaytee
 
Posts: n/a
Default 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