IF with IF AND

[DarrylBurge]

So. I know WHY this is giving me a #VALUE! response, I am just unsure as to how to stop it.

=IF(K2=0,"",IF(AND(K2>0,F2=0),2*K2,6*K2))

IF(AND(K2>0,F2=0),2*K2,6*K2) Means either do 2*K2 OR do 6*K2, and if K2 is blank then it will return a #VALUE error

So how do I get L2 to be left blank if K2 is blank?

I know I can change
=IF(OR(DATEDIF($J2,$K$1,"y")=4,DATEDIF($J2,$K$1,"y")=9),DATEDIF($J2,$K$1,"yd")/365,"")
to
=IF(OR(DATEDIF($J43,$K$1,"y")=4,DATEDIF($J43,$K$1,"y")=9),DATEDIF($J43,$K$1,"yd")/365,0)

but the "0" makes column K to display 0%, whereas I would prefer it to be blank.

[Glenn Kennedy]

K2:
=IF(OR(DATEDIF($J2,$K$1,"y")=4,DATEDIF($J2,$K$1,"y")=9),DATEDIF($J2,$K$1,"yd")/365,"")

L2:
=IF(K2="","",IF(AND(K2>0,F43=0),2*K2,6*K2))

[TMS]

Try:

Please Login or Register  to view this content.

[TMS]

Thanks for the rep.

[FDibbins]

Darry for future reference, please do not post duplicate threads.