CODEWITHSUNDEEP
excelexcel-formulaformulaexcel-2016
BellHopByDayAmetuerCoderByNigh
BellHopByDayAmetuerCoderByNigh

Reputation: 1167

Excel IF() Formula To Check for Numeric Characters

What I am after here is if the value in cell C4 is numeric and >= 1 then I want to multiply that value by 300 and add it to C10*.26) if C4 is non numeric or is 0 then I only want to show C10*.26 in the cell

This is the formula I have

=if(C4<>"", (300*C4)+(C10*.26),(C10*.62))

Which this works, but if a non-numeric value is input then the formula errors with #VALUE!

Is the best way to combat this to encompass the formula in an IFERROR() function, or does Excel 2016 have a built in way of checking if a cell value is numeric?"

Upvotes: 3

Views: 2990

Answers (2)

user3426711
user3426711

Reputation: 353

you can try :

=IF(AND(ISNUMBER(C4),C4>=1), (300*C4)+(C10*0.26),(C10*0.62))

Hope this helps

Upvotes: 1

user4039065
user4039065

Reputation:

Try it with ISNUMBER.

=if(AND(ISNUMBER(C4), IFERROR(VALUE(C4), FALSE)), (300*C4)+(C10*.26), (C10*.62))

Upvotes: 4

Related Questions