need formula

J

jaytee

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
 
M

Mangesh Yadav

if A1 is the cell content, then use:
=IF(A1>80,(A1-80)*6,IF(A1>90,(A1-90)*2,(A1-60)*2))

- Mangesh
 
P

paul

try this
=IF(C9<80,(C9-60)*2,IF(AND(C9>=80,C9<=90),(C9-80)*6,IF(C9>90,(C9-90)*2)))
this assumes your middle range includes 80 and 90
 
Top