| 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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
combine an IF and SUM
=IF(D4="Low";SUM(E4+(E4*0,15));IF(D4="Normal";SUM( E4+(E4*0,2));IF(D4="High";
SUM(E4+(E4*0,25))))) wrote in message ... 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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
combine an IF and SUM
Question,
Is this for columns/rows of data or Just a single value? Also, you said D4 contained either Low, Normal or High (Text), but then you used it in a SUM? Dan E wrote in message ... 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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
combine an IF and SUM
I'll assume Level of Work is E4
=IF(E4="High", D4*1.25, IF(E4="Low", D4*0.75, D4)) OR =IF(E4="High", D4 + D4/4, IF(E4="Low", D4 - D4/4, D4)) Your SUM's really aren't doing anything. Dan E wrote in message ... Hi Thanks for the replies, slight typo there.. column D is entitled 'Fixed Fee' column E is entitled 'Level of Work', and needs to have three options: Normal, Low and High. Normal has no change, Low has -25% from fixed fee and High has +25% on fixed fee. column f displays the fixed fee + level of work to get it's new value. I have used this formula... =IF(Level of Work="High",SUM(D4+(D4/4))) which works fine. However, I now need to add the level of work for low and normal and am again...stumpted!! :( I tried... =IF(Level of Work="High",SUM(D4+(D4/4),IF(Level of Work="Low",SUM(D4-D4/4)))) but if i then change the value in 'level of work' to low, i am greeted with #FALSE. "Dan E" wrote in message ... Question, Is this for columns/rows of data or Just a single value? Also, you said D4 contained either Low, Normal or High (Text), but then you used it in a SUM? Dan E wrote in message ... 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 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
combine an IF and SUM
Hi Thanks for the replies, slight typo there..
column D is entitled 'Fixed Fee' column E is entitled 'Level of Work', and needs to have three options: Normal, Low and High. Normal has no change, Low has -25% from fixed fee and High has +25% on fixed fee. column f displays the fixed fee + level of work to get it's new value. I have used this formula... =IF(Level of Work="High",SUM(D4+(D4/4))) which works fine. However, I now need to add the level of work for low and normal and am again...stumpted!! :( I tried... =IF(Level of Work="High",SUM(D4+(D4/4),IF(Level of Work="Low",SUM(D4-D4/4)))) but if i then change the value in 'level of work' to low, i am greeted with #FALSE. "Dan E" wrote in message ... Question, Is this for columns/rows of data or Just a single value? Also, you said D4 contained either Low, Normal or High (Text), but then you used it in a SUM? Dan E wrote in message ... 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 |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
combine an IF and SUM
Wow, thank you so much!! Works excellently; Im a total beginner to Excel so
appologies for my dumbass-ness :) I guess I was going wrong in that I wasnt specifying a false value? "Dan E" wrote in message ... I'll assume Level of Work is E4 =IF(E4="High", D4*1.25, IF(E4="Low", D4*0.75, D4)) OR =IF(E4="High", D4 + D4/4, IF(E4="Low", D4 - D4/4, D4)) Your SUM's really aren't doing anything. Dan E wrote in message ... Hi Thanks for the replies, slight typo there.. column D is entitled 'Fixed Fee' column E is entitled 'Level of Work', and needs to have three options: Normal, Low and High. Normal has no change, Low has -25% from fixed fee and High has +25% on fixed fee. column f displays the fixed fee + level of work to get it's new value. I have used this formula... =IF(Level of Work="High",SUM(D4+(D4/4))) which works fine. However, I now need to add the level of work for low and normal and am again...stumpted!! :( I tried... =IF(Level of Work="High",SUM(D4+(D4/4),IF(Level of Work="Low",SUM(D4-D4/4)))) but if i then change the value in 'level of work' to low, i am greeted with #FALSE. "Dan E" wrote in message ... Question, Is this for columns/rows of data or Just a single value? Also, you said D4 contained either Low, Normal or High (Text), but then you used it in a SUM? Dan E wrote in message ... 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 |
| Reply |
| 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 | |||
Linear Mode
