| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
CALCULATION BASED ON MORE THAN TWO CONDITIONS
Please would someone help me again?
I need to come up with a value in one cell dependent on conditions being met or not met in another. eg: if value in A1 is zero return value in A2 as zero, but if value in A1 is greater than zero but less than 240 return a value of 240, however if value in A1 is over 240 return whatever value it is in A2. Hope this makes sense. Kind regards Eclaires |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| shade cells based on conditions - i have more than 3 conditions | Excel Worksheet Functions | |||
| Counting based upon 2 conditions that are text based | Excel Discussion (Misc queries) | |||
| Sum based on two conditions | Excel Worksheet Functions | |||
| Sum based on conditions | Excel Discussion (Misc queries) | |||
| Use different formula to calculation based on conditions | Excel Discussion (Misc queries) | |||
Threaded Mode
