combine an IF and SUM

  • Thread starter Thread starter marmite
  • Start date Start date
M

marmite

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
 
=IF(D4="Low";SUM(E4+(E4*0,15));IF(D4="Normal";SUM(E4+(E4*0,2));IF(D4="High";
SUM(E4+(E4*0,25)))))
 
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
 
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
 
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.
 
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?
 
Back
Top