ExcelBanter - plus and minus

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - plus and minus (https://www.excelbanter.com/excel-worksheet-functions/156237-plus-minus.html)

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

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
--
Traa Dy Liooar

Jock

"ekkeindoha" wrote:

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