How do I further modify it so that if G17<H17 it also equals zero?
M M. Stanley Jan 14, 2005 #3 Thanks Debra! Debra Dalgleish said: Modify the formula to: =IF(OR(H17=0,G17-H17<=0),0,(G17-H17)*1.5) Click to expand...
Thanks Debra! Debra Dalgleish said: Modify the formula to: =IF(OR(H17=0,G17-H17<=0),0,(G17-H17)*1.5) Click to expand...
D Dana DeLouis Jan 14, 2005 #4 What you have is better, but something I was experimenting with suggested the following: =(3*(G17-H17)/2)*(G17>H17)*(H17<>0) Hope this came out right. -- Dana DeLouis Win XP & Office 2003 M. Stanley said: Thanks Debra! Click to expand...
What you have is better, but something I was experimenting with suggested the following: =(3*(G17-H17)/2)*(G17>H17)*(H17<>0) Hope this came out right. -- Dana DeLouis Win XP & Office 2003 M. Stanley said: Thanks Debra! Click to expand...
