AnsweredAssumed Answered

AND OR nested formulas in calculation fields

Question asked by MikeF_1 on Jun 8, 2012
Latest reply on Jun 8, 2012 by raybaudi

Title

AND OR nested formulas in calculation fields

Post

 

Have the following formula in Excel that I need to duplicate in an FM calc field.

I will wrestle around with the logistics, but can't seem to find any documentation on syntax for this type of formula.

Can it be accomplished?

 

=IF(OR(GC="",GC=0),"",IF(VP="Plus","",IF(AND(VP="VS",SR>GL),SR*AB15,"Less Than GC")))

 

Thanks,

 - Mike

Outcomes