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