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

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

- Mangesh


"jaytee" (nospam) wrote in message
...
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

try this
=IF(C9<80,(C9-60)*2,IF(AND(C9=80,C9<=90),(C9-80)*6,IF(C990,(C9-90)*2)))
this assumes your middle range includes 80 and 90
--
paul
remove nospam for email addy!



"jaytee" wrote:

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