Hi There,
In cell H168 I have a sum function =SUM(H154:H167)
In cell H165 i have a formula:
=IF($G168>49,"2,500",IF($G168>44,"2,000",IF($G168>39,"1,600",IF($G168>34,"1,200",IF($G168>29,"900",IF($G168<30,""))))))
the problem is that the it does not add the value of cell H165 into the total sum...
Is there a problem in my function? Maybe it doesn't recognize the value of H165 as a number, if so what do I need to change?
Bookmarks