Converting IFERROR Text to a Number

I've been using IFERROR to avoid a DIV/0 error and return a figure of "100%".

This is because its for completion rates, where if there is nothing that needs to be completed it needs to be considered as 100% complete. The problem with this is that I need to use this 100% completion rate elsewhere but because its essentially text it cant be used.

Is there a way around this?

Don't put quotes around the number - those turn the returned value to text.

Hope this helps.

Pete

Haha, thanks Pete. Never knew that. I thought the quotes just specified what needed to be returned, not that it needed to be text. Sorted.