Then the formula below is correct.
"Colin2u" wrote:
=IF(J48 = 25 or highter then add J48 to I48 and have the result be submitted
in cell K48.
"ellmcg" wrote:
=IF(J48<25,I48,I48+J48)
(I think the issue got confused a bit along the way)
You will still need to decided what to do if J48 = 25!
"Colin2u" wrote:
THIS gives me "#VALUE" WHEN I MAKE J48 BE LESS THAN 25. IT WORKS WHEN J48 IS
GREATER THAN 25 BUT NOT WHEN J48 IS LESS THAN 25.
"y_not" wrote:
=if(j48<25,"",if(j4825,j48+i48))
--
y_not
------------------------------------------------------------------------
y_not's Profile: http://www.excelforum.com/member.php...o&userid=19947
View this thread: http://www.excelforum.com/showthread...hreadid=394739