If statement not working properly??

[thewiseguy]

Can anyone help me understand why this is not working properly?

v2024.34.xlsm
	BC	BD
4	Qty.	Unit MATERIAL Cost
5	0	Yes
Helper

Cell Formulas
Range	Formula
BC5	BC5	=Input!AM4
BD5	BD5	=IF(BC5>0,"Yes","No")

Here is the data from "INPUT"

v2024.34.xlsm
	AL	AM
3	Allocate?	Allocated Qty.
4		0
Input

Cell Formulas
Range	Formula
AM4	AM4	=IF(AL4="Yes",U4,"0")

 

[Joe4]

0 is not the same as "0" (anything between quotes is treated as literal text).

Change your formula in cell AM4 to this:

=IF(AL4="Yes",U4,0)

 

[thewiseguy]

0 is not the same as "0" (anything between quotes is treated as literal text).

Change your formula in cell AM4 to this:

=IF(AL4="Yes",U4,0)

ahh. thank you Joe.

 

[Joe4]

You are welcome.

Please Note: In the future, when marking a post as the solution, please mark the post that contains the solution (not your own post acknowledging that some other post was the solution).
When a post is marked as the solution, it is then shown right underneath the original question so people viewing the question can easily see the question and solution in a single quick glance without having to hunt through all the posts.

I have updated this thread for you.