Simple formula question

[ariel20029]

Hi, I hope you can help..


I have a simple formula where if AP6 cell =0 then I need the formula to return blank then proceed to the regular formula, but its not working.. Please help.
Sharon

[TABLE="width: 104"]
<tbody>[TR]
[TD]=IF(AP6=0,"",IF(R6>Q6,"CHECK","")) [/TD]
[/TR]
</tbody><colgroup><col></colgroup>[/TABLE]

[TABLE="width: 104"]
<tbody>[TR]
[TD] [/TD]
[/TR]
</tbody><colgroup><col></colgroup>[/TABLE]

 

[RoryA]

What does "not working" mean? That formula looks OK based on your description.

 

[gaz_chops]

Looks like it should work! What is in R6/Q6?

 

[ariel20029]

Hi, I think the problem is the cells that generate AP are vlookup formulas from another sheet and even though they are showing as 0 there is something causing the formula to not see the cell as actually zero. When I manually type in a 0 the formula works. Any suggestions?

thanks a million,
Sharon

 

[RoryA]

What are the formulas in AP?