+ Start a Discussion
Laura Cole 7Laura 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.
ravi soniravi soni
hi Laura,
try below code.
IF(Field_A__c > (Field_B__c*1.1),true,
IF( ((Field_C__c  *12) / Field_A__c ) < Field_D__c,true,
IF(  (Field_C__c *12) / Field_A__c ,true,false)))
let me know if it helps you by marking it as best answer.
Thank you
 
Suraj Tripathi 47Suraj Tripathi 47
Hii Laura Cole,

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
Laura Cole 7Laura Cole 7
The (Field C * 12) / Field A should be the formula posted if the other two items are not true. 

Also, with the use of True/False - it gives me the message:


 Error: Incorrect parameter type for function 'IF()'. Expected Boolean, received Number