SUM AND IF FUCTION?
SUM AND IF FUCTION?
(OP)
I want to add a percentage of a figure to a figure...
=SUM(A1+(A1*(40/100)))
If A1 = £10 then the answer would be £14.
but the minimum figure I want to add on is £10, so the answer I require is £20.
Therefore how can I write a statement which would calculate the original sum, but if it was less than £10 would add £10 in lieu of the £4 as worked out by the original sum.
=SUM(A1+(A1*(40/100)))
If A1 = £10 then the answer would be £14.
but the minimum figure I want to add on is £10, so the answer I require is £20.
Therefore how can I write a statement which would calculate the original sum, but if it was less than £10 would add £10 in lieu of the £4 as worked out by the original sum.





RE: SUM AND IF FUCTION?
RE: SUM AND IF FUCTION?
RE: SUM AND IF FUCTION?
=MIN(A1*1.4,A1+10)
-handleman, CSWP (The new, easy test)
RE: SUM AND IF FUCTION?
-handleman, CSWP (The new, easy test)
RE: SUM AND IF FUCTION?
or if B1 contains the % you want to increase by
=IF(A1<10,A1,A1*(1+B1/100))
the =MAX... option is suitable only if you want to increase the value to a minimum of £10.
RE: SUM AND IF FUCTION?
-handleman, CSWP (The new, easy test)
RE: SUM AND IF FUCTION?
The sum function adds up the values of a series of cells. It does not appear to do whatever you think its doing.
But a somif funtion exists where you only add the sells up that fit a criteria. Check it out yourself
Best regards
Morten
RE: SUM AND IF FUCTION?
The SUM function adds up a series of values. They can be individual cells, numbers, ranges, anything.
That said, in the formula =SUM(A1+(A1*(40/100))) the SUM function is indeed doing nothing. A1+(A1*(40/100)) by itself already evaluates to a single number. Putting that inside SUM is just summing a single number, exactly like =SUM(150).
-handleman, CSWP (The new, easy test)