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