Help with formula ,"")
 

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

Help with formula ,"")
 

Try it as:
=IF(P16="","",IF(P16=0,G16*L16,IF(P160,G16*L16*P1 6,"")))
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Frances C" wrote:
I have this formula that works fine:
=IF(P160,G16*L16*P16,IF(P16=0,G16*L16)) I want it to be invisible and
everytime I want to incert ,"") it becomes an error.

Help with formula ,"")
 

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

"Max" wrote:

Try it as:
=IF(P16="","",IF(P16=0,G16*L16,IF(P160,G16*L16*P1 6,"")))
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Frances C" wrote:
I have this formula that works fine:
=IF(P160,G16*L16*P16,IF(P16=0,G16*L16)) I want it to be invisible and
everytime I want to incert ,"") it becomes an error.

Help with formula ,"")
 

"Frances C" wrote...
I have this formula that works fine:

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

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

Reformatting your formula

=IF(
P160,
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 "" ?

Help with formula ,"")
 

"Frances C" wrote...
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?

"Frances C" wrote:
....
=IF(P160,G16*L16*P16,IF(P16=0,G16*L16))
....

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

Help with formula ,"")
 

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(P1 60,G16*L16*P16,"")))
which will only compute if all 3 cells are populated, otherwise the formula
cell will appear blank: ""
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Frances C" wrote:
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