If And Statement returning #VALUE

[AESP920]

Hi,

Im looking for some help to resolve this formula. I got the first part of the formula to work but I cant get the 2nd part to return a blank or a zero if its Custom. I want if cell B5 = Custom to return blank. But I know I have to make a true and false so thats why i did blank and zero. But it still doesnt work. Here is what I have:

IF(AND(B5="Fixed",AK5>=76.5%,AK5<=103.5%),"Y","N"),IF(B5="Custom"," ",0)

Thanks in advance for the help!

AESP

[TMS]

It could be because you've got two IF statements ;-)

Please Login or Register  to view this content.

Each has its own test and values for True and False.

I'm not sure how you want/need to combine them, if at all.

Regards

[daddylonglegs]

Try like this

=IF(B5="Custom","",IF(AND(B5="Fixed",AK5>=76.5%,AK5<=103.5%),"Y","N"))

[TMS]

Maybe:

Please Login or Register  to view this content.

[AESP920]

Thank you daddylonglegs!