if formula and blank conflict

[tmk0427]

Hi, I have the following formula in cell AL7 =IF(D7="RT94010",($AZ$3*$AZ$2*$AL$2)-(AK7*$AL$2),IF(D7<>"RT94010","",IF(D7="0",""))). In cell AZ7 I have the following formula =IF(AL7>0,($AZ$3*$AZ$2)-AK7,IF(AL7=0,"",IF(AL7="",""))). When I copy AL7 with it's formula down the column the cell AZ7 calculates the formula as if the value in cell AL7 is greater than 0 when it really is blank. It seems the formula in cell AL7 is being treated as if it is greater than zero. How do I get AZ7 to treat AL7 to be blank? BTW, AZ3 is the number 4 and AZ is 26 and AK7 is 83 and AL2 is 24.93.

Thanks. TK

 

[Sergius]

Hello! Is this what you wanted?

=IF(AL7<>"";($AZ$3*$AZ$2)-AK7;"")

 

[tmk0427]

Let me try and get back to you. Thanks.

 

[tmk0427]

Hello! Is this what you wanted?

=IF(AL7<>"";($AZ$3*$AZ$2)-AK7;"")

It worked when I changed ; to , Thanks.

 

[Peter_SSs]

It worked when I changed ; to , Thanks.

Given that the ; or , separator issue is just an Excel language version difference, post #2 really contains the solution to your question. The marked solution has been changed accordingly. In your future questions, please mark the post as the solution that actually answered your question, instead of your feedback message as it will help future readers. No further action is required for this thread.

 

[Alex Blakenburg]

I have the following formula in cell AL7 =IF(D7="RT94010",($AZ$3*$AZ$2*$AL$2)-(AK7*$AL$2),IF(D7<>"RT94010","",IF(D7="0",""))).

I know this was not your question but the formula in AL7 can be reduced to this:

=IF(D7="RT94010",($AZ$3*$AZ$2*$AL$2)-(AK7*$AL$2),"")

Since your first test is ="RT94010", then by definition the Else part of the IF statement is <>"RT94010" and this covers both ="0" and =0 (text 0 and numeric 0), so your additional IF statements add no value.