Hi,
I noticed the options to use IFEMPTY, IFNOTEMPTY, etc but cannot fathom out how to use it in this scenario…
I have an empty field (X) that, when populated, is used in a calculation in another field (Y).
The field (Y) calculation has other variables in it.
If (X) is blank, (Y) still performs the calculation, which shows an inaccurate answer as it is very dependent on the (X) value.
How do I stop the (Y) calculation being performed until (X) has been populated?
Probably a very easy answer but I have my ‘Dim’ hat on today. :-)
Many thanks
.
