I am wanting to make a field auto-fill depending on whether another field is empty or not.
E.g. If someone enters a voucher number in the ‘voucher number’ field, the field ‘cost’ is automatically $0. If the voucher number field is left blank, the ‘cost’ is $100.
I’ve tried using the IF function and making it blank but it is saying invalid.