| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#10
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#11
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#12
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#13
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#14
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 - |
|
#15
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 - |
|
#16
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 - |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Average Formula to display blank cell if named range is blank | Excel Worksheet Functions | |||
| Making a Cell turn color based on results in another cell | Excel Discussion (Misc queries) | |||
| References to Blank Cells turn into Zeros | Excel Worksheet Functions | |||
| COPY A CONCATENATE CELL TO BLANK CELL PUTTING IN THE NEXT BLANK C. | Excel Discussion (Misc queries) | |||
| Addition to Turn cell red if today is greater or equal to date in cell | New Users to Excel | |||
Linear Mode
