How do I do several formulas in one cell?
OH, THIS IS GREAT! It WORKED! THANK U, THANK U, THANK U Very Much!
"Sloth" wrote:
In this case you can use the following formula
=200*(C80)+150*(C83)+150*(C85)
On a side note, you are using AND and OR incorrectly. The following formula
will also do what you describe.
=IF(C8<=0,0,IF(AND(C80,C8<=3),200,IF(AND(C83,C8< =5),350,IF(C85,500))))
of course it can be simplified to what has already been offered (with a
slight modification) to this
=IF(C85,500,IF(C83,350,IF(C80,200,0)))
|