How to set minus value to 0
=if((b1-a1)<=0,0,value)
Best wishes
Sreedhar
"TSK" wrote:
How to focus the value to zero after minus from 2 cells otherwise show the
actual value different?
A1 - 100 / B1 - 50
If B1 - A1 is not <= 0 show the value different and if B1 - A1 is <=0 then
reflect the number as 0
|