SharePoint - Nested Formula - Asked By V. on 03-Apr-13 01:55 PM

Can anyone help me combine these two formulas into one nested formula?

Thanks -


=IF(and([Imp Year]=2014,[Imp M No]<=1,

If True, bring back [Savings Per M]

If false, bring back $0.00

IF (SUM([Jan-13],[Feb-13],[Mar-13],[Apr-13],[May-13],[Jun-13],[Jul-13],[Aug-13],[Sep-13],[Oct-13],[Nov-13],[Dec-13]))<[Total Savings]

If True, bring back [Savings Per M]

If false, bring back $0.00