Calculation not adding up.

[Rebmit1]

Hi i have an excel sheet which tracks courses undertaken and when dates are close to expiring and to display if they are out of date. I use the following formula to also show them as either 100% complete not 0% if they are out of date.

=IF(ISBLANK(F18),"",IF(F18<TODAY(),"0","100"))

The formula works well and displays the 0 or 100 correctly however i have multiple rows for each course and i want the 100s to sum up at the bottom of the sheet. The issue is the 100s dont register as a number so wont calculate.

Does anyone have any thoughts why this may be?

 

[Habtest]

Try removing quotes around the "100"

=IF(ISBLANK(F18),"",IF(F18<TODAY(),0,100))

 

[Rebmit1]

Try removing quotes around the "100"

=IF(ISBLANK(F18),"",IF(F18<TODAY(),0,100))

Thank you, a really quick reply to which i appreciate. That worked perfectly.

 

[Habtest]

Thank you, a really quick reply to which i appreciate. That worked perfectly.

Glad it works. Thanks for the feedback.