How can prevent getting a "0" in the cell where I place this formula?

[Romano_odK]

Good afternoon,

I have this formula in multiple cells and every one of them has a "0". Ok I can turn all "0" off but that is not what I need. Can I prevent this?

Thank you for your time.

=IF(AX6>0;AY6-(AY6*AX6);AY6)

 

[etaf]

i assume you get this when AY is blank or zero
what would you want if AY6 was a zero ?

=IF(AND(AX6>0,OR(AY6<>"",AY6>0));AY6-(AY6*AX6);AY6)

will still give a zero if AY6 contains a zero

 

[Special-K99]

i assume you get this when AY is blank or zero
what would you want if AY6 was a zero ?

=IF(AND(AX6>0,OR(AY6<>"",AY6>0));AY6-(AY6*AX6);AY6)

will still give a zero if AY6 contains a zero

If AX6 is 1 then AY6-(AY6*AX6) will still result in 0, irrespective of the value in AY6
Am unsure why the brackets are there tbh!
Should just be

AY6-AY6*AX6

 

[SimpleDAS]

This might be a slightly convoluted option, but I hate this as well, and there is a simple fix using conditional formatting

You can set up a rule that specifies it requires the cell value to be 0 (this will work even though the actual content may be a formula)
You can then set the formatting rules to just have the text colour the same as the background colour of your cell!

It is simpler than trying to add variables to your formula and can easily be adjusted to encompass all ranges you need it to
In my case it spans from cell D14 to cell J14

Good luck!
Your friendly Internet Simple_DSA

 

[Romano_odK]

i assume you get this when AY is blank or zero
what would you want if AY6 was a zero ?

=IF(AND(AX6>0,OR(AY6<>"",AY6>0));AY6-(AY6*AX6);AY6)

will still give a zero if AY6 contains a zero

AY6 will always be higher then zero, so that is not a problem.

 

[Romano_odK]

If AX6 is 1 then AY6-(AY6*AX6) will still result in 0, irrespective of the value in AY6
Am unsure why the brackets are there tbh!
Should just be

AY6-AY6*AX6

True, changed that.

 

[Special-K99]

AY6 will always be higher then zero, so that is not a problem.

If AY6 will always be greater than 0, then where 0 is the result of that formula, AX6 must be 1

AY6-AY6*AX6