Excel Dumps Formula

[Peter Lockwood]

Greetings All
Has Anyone Else hade Random Instances With Excel 365 Replacing Basic Formulas with a Text Value of "#VALUE"

this Happens on only one VBA Template but I totally Random

Hope you Can Shed light on this

Regards
Peter Lockwood

 

[jasonb75]

#VALUE! is a formula error caused by attempting to perform a mathematical operation on a text string which cannot be recognised as a valid number.
If you're seeing it as a text string in a cell then that would mean that something in your vba is converting formulas to values.

 

[Peter Lockwood]

Basic formula id the One Being Dumped
Formula in question Is IFERROR(ROUNDDOWN($AA10-($U10*$Y10)-($AB10*28)-($Z10*$U10),1),"")
prior to the Update No Issues

 

[jasonb75]

The formula would generate #VALUE! if any of the cells contained a non-numeric string, but it should be suppressed by IFERROR.
Is there anything in the vba that manipulates the cell with the formula under specific conditions?