Kay;350927 Wrote:
I have the formula if($0$3<=20,2) I want to over ride to equal 0 (zero)
if
cell D60 = N
--
KK

Try this,

=IF($O$3<=20,2,IF(D60="N",0,""))


--
oldchippy
------------------------------------------------------------------------
oldchippy's Profile: http://www.thecodecage.com/forumz/member.php?userid=111
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=98204