Formulas to not be counted as objects in a cell

[katiapro93]

I have two rows that I want to match with a simple "IF" formula, but it is not working on account that on row is full of formulas bring back specific info from another sheet and the 2nd row is currency I write in. Any suggestions on how I can make excel think that the first row is empty?

1st row 2nd row 3rd row
=if($I3090="Y",vlookup($H3090,Pricelist!$A:$F,6,false),"$0.00") $0.00 =if(1st row=2nd row,"Y","N")

 

[Jonmo1]

The short answer is you can't.
If the cell contains a formula, then it in fact contains a formula.
There is nothing you can do in another formula to make it consider the original cell with a formula as Empty.

Basically, a formula cannot return 'Nothing', it MUST return Something...

The closest we can get to making a formula return as Empty, is to make it return a 0 length Text String ""
=if($I3090="Y",vlookup($H3090,Pricelist!$A:$F,6,false),"")

But that is still not Empty, it's a TEXT string.

Then you can do
=If(1st Row = "","N","Y")

 

[jtakw]

Hi,

Not sure if this helps:

Excel 2010
	A	B	C
1	$0.00
2	$0.00	$0.00	$0.00
3	Y	N	N
4
5	A1 is "$0.00" as result of formula	B1 is Truly blank	C1 is "" as result of formula
Sheet1

Cell Formulas
Range	Formula
A1	="$0.00"
A3	=IF(A1="","N",IF(A1+0=A2,"Y",""))
C1	=""

 

[Jonmo1]

If you want this formula
=if($I3090="Y",vlookup($H3090,Pricelist!$A:$F,6,false),"$0.00")
To match the 0 you actually typed by hand in the other cell, just put a 0 without quote marks

=if($I3090="Y",vlookup($H3090,Pricelist!$A:$F,6,false),0)

 

[jtakw]

If you want this formula
=if($I3090="Y",vlookup($H3090,Pricelist!$A:$F,6,false),"$0.00")
To match the 0 you actually typed by hand in the other cell, just put a 0 without quote marks

=if($I3090="Y",vlookup($H3090,Pricelist!$A:$F,6,false),0)

Yes, that would be the correct way to do it, and you can still have that cell formatted as Currency.
Then you can just use your formula in OP, =if(1st row=2nd row,"Y","N")

Excel 2010
	D
1	$0.00
2	$0.00
3	Y
4
5	Your formula in OP
Sheet1

Cell Formulas
Range	Formula
D1	=0
D3	=IF(D1=D2,"Y","N")

 

[katiapro93]

Thank you guys, both answers were interesting and I learned new things. I actually did what Jonmo1 said, just put a 0 instead of "0" or "$0.00" and it gave me what I needed. Thank you!

 

[Jonmo1]

You're welcome.