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
|