Multiple conditions to a formula in one cell

[Audra]

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

 

[Don Guillett]

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

 

[Bernie Deitrick]

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

 

[Gary''s Student]

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

If you have many more options, then use a VLOOKUP() table.

 

[Sheeloo]

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