ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   How do I do several formulas in one cell? (https://www.excelbanter.com/excel-worksheet-functions/166243-how-do-i-do-several-formulas-one-cell.html)

imktew

How do I do several formulas in one cell?
 
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?



Elkar

How do I do several formulas in one cell?
 
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?



Sloth

How do I do several formulas in one cell?
 
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)))

imktew

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?



imktew

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)))



All times are GMT +1. The time now is 08:37 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com