How do I do several formulas in one cell?
It all worked except for the=0,200 - It put in 200 and it should have been 0.
THANKS!
"Elkar" wrote:
See if this does what you're looking for:
=IF(C8=5,500,IF(C8=3,350,IF(C8=0,200,0)))
HTH,
Elkar
"imktew" wrote:
I am in the process of trying to get this formula to work.
=IF(C80,200,0)*OR(C8<3,200,0)*OR(C8=3,350)*AND(C8 3,350)*OR(C8<5,350)*OR(C85,500)*OR(C8=5,500)
For example I am trying to figure times. So greater than 0 and less than 3
= 200 plus equal to 3, greater than 3 and less than 5 = 350, great than 5 =
500.
For some reason it's just calculating the first formula for 200. Can anyone
please help with this?
|