JMRKER thanks so much for your help!!
There was a mistake in my formula! Sorry about that it was supposed to be:
=IF((E90.05)>2, E90.06, 2)
I have the formula answer going into a field called "result".
Is the figure entered into E9a going into 'v' variable?
Many thanks for your help again...
Hope you can help me further as I cannot get the formula to work!
JMRKER;1273969 wrote:Uses 'onblur' to effect change, but you can alter to some other event ...
<!DOCTYPE HTML>
<html>
<head>
<title> Untitled </title>
<meta charset="utf-8">
</head>
<body>
<table border="1"><tr>
<td><input type="text" id="E9a" value="1" onblur="adjustFormula(this.value)"></td>
<td><input type="text" id="E9b" value=""></td>
</tr></table>
<script type="text/javascript">
function adjustFormula(v) {
v = Number(v);
if (v >= 2) { document.getElementById('E9b').value = (v * 0.05).toFixed(2); }
else { document.getElementById('E9b').value = 2; }
}
</script>
</body>
</html>