Excel SUMIF + ROUND in one formula
Solved
platinium
-
platinium -
platinium -
Hello,
I want to sum 3 cells, where one will only be counted and rounded up to the next whole number if the number in that cell is greater than 0.
For example:
H30=10
M30=3
L=0.1
I want the result to be: 14. But if L= -0.3, then I don’t want it to be counted.
This formula should fit into a single cell. It would be something like:
=SUM(H30+M30)+IF(L30>0,ROUNDUP(0))
Of course, this doesn’t work and despite my research, I can't find this formula.
If you have the solution!!!
Thanks in advance.
I want to sum 3 cells, where one will only be counted and rounded up to the next whole number if the number in that cell is greater than 0.
For example:
H30=10
M30=3
L=0.1
I want the result to be: 14. But if L= -0.3, then I don’t want it to be counted.
This formula should fit into a single cell. It would be something like:
=SUM(H30+M30)+IF(L30>0,ROUNDUP(0))
Of course, this doesn’t work and despite my research, I can't find this formula.
If you have the solution!!!
Thanks in advance.
Configuration: Windows Vista Internet Explorer 7.0
2 answers
-
Great,
thank you for the solution, it saves me from having a hidden column. I wasn't far off since I managed, with some difficulty, to come up with this formula:
=IF(L30>0,CEILING(L30,0),0) and then I used the result for the sum: =SUM(H30+M30+N30).
It wasn't missing much!!!!
Thank you gbinforme! -
Hello
If you use the right syntax, your formula works.=SUM(H30+M30)+IF(L30>0,ROUNDUP(L30,0),0)
--
always Zen
