turn #value into blank cell
 

My formula is (A5/B5)-1

is there a way to change this so that if A5 and B5 are empty it displays an
empty cell?

turn #value into blank cell
 

=IF(COUNT(A5:B5)=2,(A5/B5)-1,"")
--
If this post helps click Yes
---------------
Jacob Skaria


"amik" wrote:

My formula is (A5/B5)-1

is there a way to change this so that if A5 and B5 are empty it displays an
empty cell?

turn #value into blank cell
 

Hi, use

=iferror( (A5/B5)-1,"")

"amik" wrote:

My formula is (A5/B5)-1

is there a way to change this so that if A5 and B5 are empty it displays an
empty cell?

turn #value into blank cell
 

that formula makes them all empty, even when there are numbers present?

any advice?

"Jacob Skaria" wrote:

=IF(COUNT(A5:B5)=2,(A5/B5)-1,"")
--
If this post helps click Yes
---------------
Jacob Skaria


"amik" wrote:

My formula is (A5/B5)-1

is there a way to change this so that if A5 and B5 are empty it displays an
empty cell?

turn #value into blank cell
 

That gives me a #name....

"Eduardo" wrote:

Hi, use

=iferror( (A5/B5)-1,"")

"amik" wrote:

My formula is (A5/B5)-1

is there a way to change this so that if A5 and B5 are empty it displays an
empty cell?

turn #value into blank cell
 

OPPss, there was an extra space

=iferror((A5/B5)-1,"")

"amik" wrote:

That gives me a #name....

"Eduardo" wrote:

Hi, use

=iferror( (A5/B5)-1,"")

"amik" wrote:

My formula is (A5/B5)-1

is there a way to change this so that if A5 and B5 are empty it displays an
empty cell?

turn #value into blank cell
 

The formula works only if there are 2 values; or otherwise return blank. Are
you trying the range A5:B5 itself.

If this post helps click Yes
---------------
Jacob Skaria


"amik" wrote:

that formula makes them all empty, even when there are numbers present?

any advice?

"Jacob Skaria" wrote:

=IF(COUNT(A5:B5)=2,(A5/B5)-1,"")
--
If this post helps click Yes
---------------
Jacob Skaria


"amik" wrote:

My formula is (A5/B5)-1

is there a way to change this so that if A5 and B5 are empty it displays an
empty cell?

turn #value into blank cell
 

that formula makes them all empty, even when there are numbers present?

That means your numbers aren't numeric numbers but are TEXT numbers.


--
Biff
Microsoft Excel MVP


"amik" wrote in message
...
that formula makes them all empty, even when there are numbers present?

any advice?

"Jacob Skaria" wrote:

=IF(COUNT(A5:B5)=2,(A5/B5)-1,"")
--
If this post helps click Yes
---------------
Jacob Skaria


"amik" wrote:

My formula is (A5/B5)-1

is there a way to change this so that if A5 and B5 are empty it
displays an
empty cell?

turn #value into blank cell
 

for some reason it is still giving me an # name statement...



"Eduardo" wrote:

OPPss, there was an extra space

=iferror((A5/B5)-1,"")

"amik" wrote:

That gives me a #name....

"Eduardo" wrote:

Hi, use

=iferror( (A5/B5)-1,"")

"amik" wrote:

My formula is (A5/B5)-1

is there a way to change this so that if A5 and B5 are empty it displays an
empty cell?

turn #value into blank cell
 

Yeah I am trying to get my formuala to calculate two vlookups....

Is that not possible?

"T. Valko" wrote:

that formula makes them all empty, even when there are numbers present?

That means your numbers aren't numeric numbers but are TEXT numbers.


--
Biff
Microsoft Excel MVP


"amik" wrote in message
...
that formula makes them all empty, even when there are numbers present?

any advice?

"Jacob Skaria" wrote:

=IF(COUNT(A5:B5)=2,(A5/B5)-1,"")
--
If this post helps click Yes
---------------
Jacob Skaria


"amik" wrote:

My formula is (A5/B5)-1

is there a way to change this so that if A5 and B5 are empty it
displays an
empty cell?

turn #value into blank cell
 

=IF(COUNT(INT(A5),INT(B5))=2,(A5/B5)-1,"")
--
If this post helps click Yes
---------------
Jacob Skaria


"amik" wrote:

Yeah I am trying to get my formuala to calculate two vlookups....

Is that not possible?

"T. Valko" wrote:

that formula makes them all empty, even when there are numbers present?

That means your numbers aren't numeric numbers but are TEXT numbers.


--
Biff
Microsoft Excel MVP


"amik" wrote in message
...
that formula makes them all empty, even when there are numbers present?

any advice?

"Jacob Skaria" wrote:

=IF(COUNT(A5:B5)=2,(A5/B5)-1,"")
--
If this post helps click Yes
---------------
Jacob Skaria


"amik" wrote:

My formula is (A5/B5)-1

is there a way to change this so that if A5 and B5 are empty it
displays an
empty cell?

turn #value into blank cell
 

Hi
For me is working, I copy the formula agaiun

=IFERROR((A5/B5)-1,"")



"amik" wrote:

for some reason it is still giving me an # name statement...



"Eduardo" wrote:

OPPss, there was an extra space

=iferror((A5/B5)-1,"")

"amik" wrote:

That gives me a #name....

"Eduardo" wrote:

Hi, use

=iferror( (A5/B5)-1,"")

"amik" wrote:

My formula is (A5/B5)-1

is there a way to change this so that if A5 and B5 are empty it displays an
empty cell?

turn #value into blank cell
 

Oops...

=IF(ISERROR(A5/B5),"",(A5/B5)-1)

--
If this post helps click Yes
---------------
Jacob Skaria


"Jacob Skaria" wrote:

=IF(COUNT(INT(A5),INT(B5))=2,(A5/B5)-1,"")
--
If this post helps click Yes
---------------
Jacob Skaria


"amik" wrote:

Yeah I am trying to get my formuala to calculate two vlookups....

Is that not possible?

"T. Valko" wrote:

that formula makes them all empty, even when there are numbers present?

That means your numbers aren't numeric numbers but are TEXT numbers.


--
Biff
Microsoft Excel MVP


"amik" wrote in message
...
that formula makes them all empty, even when there are numbers present?

any advice?

"Jacob Skaria" wrote:

=IF(COUNT(A5:B5)=2,(A5/B5)-1,"")
--
If this post helps click Yes
---------------
Jacob Skaria


"amik" wrote:

My formula is (A5/B5)-1

is there a way to change this so that if A5 and B5 are empty it
displays an
empty cell?

turn #value into blank cell
 

IFERROR is in Excel 2007 only

try this =if(iserror((A5/B5)-1),"",(A5/B5)-1)

On May 27, 12:53*pm, amik wrote:
for some reason it is still giving me an # name statement...



"Eduardo" wrote:
OPPss, there was an extra space

=iferror((A5/B5)-1,"")

"amik" wrote:

That gives me a #name....

"Eduardo" wrote:

Hi, use

=iferror( (A5/B5)-1,"")

"amik" wrote:

My formula is (A5/B5)-1

is there a way to change this so that if A5 and B5 are empty it displays an
empty cell?- Hide quoted text -

- Show quoted text -

turn #value into blank cell
 

I got it working....


Thanks for the help everyone

"Tanya" wrote:

IFERROR is in Excel 2007 only

try this =if(iserror((A5/B5)-1),"",(A5/B5)-1)

On May 27, 12:53 pm, amik wrote:
for some reason it is still giving me an # name statement...



"Eduardo" wrote:
OPPss, there was an extra space

=iferror((A5/B5)-1,"")

"amik" wrote:

That gives me a #name....

"Eduardo" wrote:

Hi, use

=iferror( (A5/B5)-1,"")

"amik" wrote:

My formula is (A5/B5)-1

is there a way to change this so that if A5 and B5 are empty it displays an
empty cell?- Hide quoted text -

- Show quoted text -

turn #value into blank cell
 

Just make note that ISERROR will hide all errors including #N/A which may be
returned from a VLOOKUP


Gord Dibben MS Excel MVP

On Wed, 27 May 2009 10:45:46 -0700, amik
wrote:

I got it working....


Thanks for the help everyone

"Tanya" wrote:

IFERROR is in Excel 2007 only

try this =if(iserror((A5/B5)-1),"",(A5/B5)-1)

On May 27, 12:53 pm, amik wrote:
for some reason it is still giving me an # name statement...



"Eduardo" wrote:
OPPss, there was an extra space

=iferror((A5/B5)-1,"")

"amik" wrote:

That gives me a #name....

"Eduardo" wrote:

Hi, use

=iferror( (A5/B5)-1,"")

"amik" wrote:

My formula is (A5/B5)-1

is there a way to change this so that if A5 and B5 are empty it displays an
empty cell?- Hide quoted text -

- Show quoted text -