AND OR nested formulas in calculation fields
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")))