L lilprintesa1028 Apr 23, 2008 #1 I need to enter a formula that will subtract two cells without getting a negative, then divide that number by 2. Any suggestions?
I need to enter a formula that will subtract two cells without getting a negative, then divide that number by 2. Any suggestions?
K ken-hup Apr 23, 2008 #2 Try this =IF((A2>A1),0,IF(((A1-A2)/2)<0,0,A1-A2/2)) This will result in required answer or 0
K ken-hup Apr 23, 2008 #4 Just to explain - If A2 is greater than A1 put 0, if A2 is less than A1 try... If A1-A2 divided by 2 is less than 0 put 0, if it is greater than 0 put answer of A1-A2 / 2 Hope this helps you understand "nested" IF statements
Just to explain - If A2 is greater than A1 put 0, if A2 is less than A1 try... If A1-A2 divided by 2 is less than 0 put 0, if it is greater than 0 put answer of A1-A2 / 2 Hope this helps you understand "nested" IF statements
