Help with formula ,"")

[Frances C]

I have this formula that works fine:
=IF(P16>0,G16*L16*P16,IF(P16=0,G16*L16)) I want it to be invisible and
everytime I want to incert ,"") it becomes an error.

 

[Max]

Try it as:
=IF(P16="","",IF(P16=0,G16*L16,IF(P16>0,G16*L16*P16,"")))

 

[Frances C]

It does not work, my original formula works, the only problem is that I do
not want to see a cero on the result cell I have not type any numbers on the
other cells, I know that if I use "" I make the cell invisible, but on the
formula P16 need to have the option to be use or not

 

[Harlan Grove]

I have this formula that works fine:

I want it to be invisible and everytime I want to incert ,"") it becomes
an error.

Reformatting your formula

=IF(
P16>0,
G16*L16*P16,
IF(
P16=0,
G16*L16
)
)

It looks like the only cases not handled are P16 not numeric and P16 < 0.
When do you want it to return "" ?

 

[Harlan Grove]

It does not work, my original formula works, the only problem is that I do
not want to see a cero on the result cell I have not type any numbers on
the other cells, I know that if I use "" I make the cell invisible, but on
the formula P16 need to have the option to be use or not

....

So you want to display "" (nothing) when G16 or L16 are blank?
....

=IF(COUNT(G16,L16)=2,G16*L16*IF(P16>0,P16,1),"")

 

[Max]

I do not want to see a zero on the result cell

if I have not type any numbers on the other cells

Try this then:
=IF(COUNT(G16,L16,P16)<3,"",IF(P16=0,G16*L16,IF(P16>0,G16*L16*P16,"")))
which will only compute if all 3 cells are populated, otherwise the formula
cell will appear blank: ""