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