Formula not working

[Ash Hayashi]

Hello.
I am trying to input a formula [ IFERROR(A8*P8, " ") ] which I typically use to hide the formula or make the cell appear blank when data is not entered into cell A8 or P8.
However, when I'm typing it in, it's still showing as [ 0 ] on the cell.

I'm not sure what I'm missing or doing wrong. Any thoughts or feedback would be appreciated.

 

[FormR]

The empty cells are evaluated as zero's and 0*0 doesn't result in an error.

You could try like this:

=IF(AND(A8<>0,P8<>0),A8*P8,"")

or like this:

=LET(m,A8*P8,IF(m=0,"",m))

 

[Ash Hayashi]

That worked perfectly. Thank you!

 

[Ash Hayashi]

Sorry, a quick follow up question.
I have added the formula's in and it seems to be working. As soon as I close the file or share it, it resets the formulas to show this:

Thoughts?

 

[FormR]

Which formula are you using? That image looks like the formula bar, which would indicate the formula is being overridden. Do you have any VBA in that workbook?

 

[Ash Hayashi]

I was using the =LET formula you suggested above.
As mentioned, whenever I close it, it resets/erases the formula to show =#VALUE!
I tried the =IF formula, and that seems to be working better.


Now I'm I'm trying to get a total at the bottom in cell Q16. It needs to sum the totals from R3 - R14. But, I wanted it to show nothing until there is actual data int he other columns.

I don't have any VBA's.

Thank you for your help!

 

[FormR]

whenever I close it, it resets/erases the formula to show =#VALUE!

I have no idea what's going on there!

I tried the =IF formula, and that seems to be working better.

It needs to sum the totals from R3 - R14. But, I wanted it to show nothing until there is actual data int he other columns.

New questions should really be in new threads, but do you mean like this?

=IF(COUNT(R3:R14),SUM(R3:R14),"")

 

[Joe4]

I was using the =LET formula you suggested above.
As mentioned, whenever I close it, it resets/erases the formula to show =#VALUE!
I tried the =IF formula, and that seems to be working better.


Now I'm I'm trying to get a total at the bottom in cell Q16. It needs to sum the totals from R3 - R14. But, I wanted it to show nothing until there is actual data int he other columns.
View attachment 122830

I don't have any VBA's.

Thank you for your help!

Are you perhaps sharing it with someone who has an older version of Excel that does not have the LET function?