View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
K. Malek K. Malek is offline
external usenet poster
 
Posts: 1
Default 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