Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Multiple conditions to a formula in one cell
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Multiple conditions in formula | Excel Worksheet Functions | |||
Need help on formula with multiple conditions... | Excel Discussion (Misc queries) | |||
How do I set up a formula with multiple conditions? | Excel Discussion (Misc queries) | |||
Formula for multiple conditions | Excel Discussion (Misc queries) | |||
Formula to return cell contents based on multiple conditions | Excel Worksheet Functions |