plus and minus

[Guest]

good day.
I need a formula for the following
A B C D E F G H
I
100 0 10 110 0
100 0 90 0 0
100 100 10 90 100
For column F, I need (if the total of C,D,E are bigger than A - B it should
show A.
For column G, I need (if the total of C,D,E are bigger than A - H it should
show C,D,E - A
For column H, I need (if the total of C,D,E are smaller than A - B it should
give the total

thanks

 

[Guest]

How about:
In F1 - =IF((SUM(C1:E1))>(A1-B1),A1,"not specified")
In G1 - =IF((SUM(C1:E1))>(A1-H1),SUM(C1:E1)-A1,"not specified"))
In H1 - =IF((SUM(C1:E1))<(A1-B1),SUM(C1:E1),"not specified")

Because G1 refers to H1 and the result there is "not specified", there's a
'#value' error.
hth