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?"