I want to be able to create multiple conditions to a formula in one cell. For
example if B2 is "Happy" than the cell should use a certain formula like
o6/e6/175 but if B2 is "sad" than the cell should use formula o6/e6/250. I
want to be able to have lots of formulas to be used with the cells that
correspond to the same row that my final data has to be placed, like if I'm
in cell J3 I need to use B3, O3, E3, and so on.

Any help?

Thanks! Audra

More info and layout or, if desired, send your wb to my address below along
with a clear explanation.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Audra" wrote in message
...
I want to be able to create multiple conditions to a formula in one cell.
For
example if B2 is "Happy" than the cell should use a certain formula like
o6/e6/175 but if B2 is "sad" than the cell should use formula o6/e6/250. I
want to be able to have lots of formulas to be used with the cells that
correspond to the same row that my final data has to be placed, like if
I'm
in cell J3 I need to use B3, O3, E3, and so on.

Any help?

Thanks! Audra

Audra,

It could be as easy as this, in cell J3 and then copied down.

=IF(B3="Happy",O3/E3/175,O3/E3/250)

HTH,
Bernie
MS Excel MVP


"Audra" wrote in message
...
I want to be able to create multiple conditions to a formula in one cell. For
example if B2 is "Happy" than the cell should use a certain formula like
o6/e6/175 but if B2 is "sad" than the cell should use formula o6/e6/250. I
want to be able to have lots of formulas to be used with the cells that
correspond to the same row that my final data has to be placed, like if I'm
in cell J3 I need to use B3, O3, E3, and so on.

Any help?

Thanks! Audra

=IF(B2="Happy",O6/E6/175,IF(B2="sad",O6/E6/250,""))

If you have many more options, then use a VLOOKUP() table.
--
Gary''s Student - gsnu200808


"Audra" wrote:

I want to be able to create multiple conditions to a formula in one cell. For
example if B2 is "Happy" than the cell should use a certain formula like
o6/e6/175 but if B2 is "sad" than the cell should use formula o6/e6/250. I
want to be able to have lots of formulas to be used with the cells that
correspond to the same row that my final data has to be placed, like if I'm
in cell J3 I need to use B3, O3, E3, and so on.

Any help?

Thanks! Audra

Enter this in J2 and copy down...
=IF(B2="Happy",O6/(E6*175),IF(B2="Sad",O6/(E6*250),"Neither happy nor sad"))

You can add another IF if you want...

Looks like only thing which is changing is the divisor (175 or 250...)
If that is the case put Happy and 175 in cells M1 N1, Sad and 250 in M2 N2
and so on and use in J2
=O6/(E6*VLOOKUP(B2,M:N,2,False))

Also if you do not want O6 and E6 to change O7 and E7 then use
O$6 and E$6 in the above formulae...


--
Always provide your feedback so that others know whether the solution worked
or problem still persists ...


"Audra" wrote:

I want to be able to create multiple conditions to a formula in one cell. For
example if B2 is "Happy" than the cell should use a certain formula like
o6/e6/175 but if B2 is "sad" than the cell should use formula o6/e6/250. I
want to be able to have lots of formulas to be used with the cells that
correspond to the same row that my final data has to be placed, like if I'm
in cell J3 I need to use B3, O3, E3, and so on.

Any help?

Thanks! Audra