You need to sign in to do that
Don't have an account?
Laura Cole 7
How to nest a formula with a formula (If/And Statement)
Here's my formula need.
IF(Field A > (Field B * 1.1)), "ERROR",
AND/OR
IF((Field C * 12 / Field A) < Field D, "Error",
Otherwise it should calulate and post
(Field C * 12) / Field A
How would I represent this? I've tried several methods. Also, tried doing a validation but the field itself isn't showing up in the validation field options when I create it.
IF(Field A > (Field B * 1.1)), "ERROR",
AND/OR
IF((Field C * 12 / Field A) < Field D, "Error",
Otherwise it should calulate and post
(Field C * 12) / Field A
How would I represent this? I've tried several methods. Also, tried doing a validation but the field itself isn't showing up in the validation field options when I create it.
try below code. let me know if it helps you by marking it as best answer.
Thank you
Try this fromula :
IF(Field A > (Field B*1.1),true,
IF( ((Field C *12) / Field A ) < Field D,true,
IF( (Field C *12) / Field A ,true,false)))
I hope you find the above solution helpful. If it does, please mark as Best Answer to help others too.
hanks and Regards,
Suraj
Also, with the use of True/False - it gives me the message:
Error: Incorrect parameter type for function 'IF()'. Expected Boolean, received Number