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
