How do I get this to ignore text?

[crof_s]

How would I get this formula to ignore the text in cell C4? I keep getting a #VALUE ! error. I want the formula to just use the numbers in the cell.

=IF(SUM(C4*5+D4)*120%>50,SUM(C4*5)*120%,SUM(C4*5+D4)*120%)

Thanks in advance.

 

[Marcílio_Lobão]

crof_s, Good evening.

Maybe I missing something.

BUT....
use format at C4 as Custom --> #.##0,00" +vat" is not an option for you?

I hope it helps.

 

[Aladin Akyurek]

Nope. For some reason when there is only 4.99 in the C4 cell then my total is fine which is £41.88 when using the formula you just provided. However, once I add the letters in the C4 cell I come up with £11.94?

If C4 must be included in the calculation, do not augment it with text. Otherwise, it becomes literally text. You might want to apply a custom format to C4.