Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
combine an IF and SUM
Wondered if any kind soul would be abel to help me...
I want a different sum to be performed dependant on the value of another field (d4 which is entitled 'Level of Work'). d4 will have one of three values, Low, Normal or High. I would like to say... IF(Level of Work=High then add 25%.... =SUM(d4+(d4/4)) But I don't know how to combine this into one statement? Any help appreciated tia |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I combine worksheets w/o enough rows to combine? | Excel Worksheet Functions | |||
Combine if | Excel Discussion (Misc queries) | |||
Combine cells with the same reference and combine quantities | Excel Discussion (Misc queries) | |||
Combine into one please | Excel Worksheet Functions | |||
Combine into one please. | Excel Worksheet Functions |