Is there anyway to return a formula if an IFS formula is true???

[BradHarrisDev]

I've been playing around with Excel to manage sales people's revenue and personal earnings.

Some of our customers pay one of fees whereas others pay instalments.

For E.g

IF(AND(g3:g17, "Contract", f3:f17, "Steven Jones"), Then perform a formula on this cell value

This is the formula I want it to carry out: =($H7/$I7)*AND(G21>=$M7,G21<$M7+$I7)

Then I want it to add this formula to the value at the end: +SUMIFS(H3:H17,G3:G17,"Jones",O3:O17,"May")

I'd be super grateful if anyone could give me any idea as to how to do this.

BRAD :)

[#2]

Hi @BradHarrisDev 

Try below formula:

=IF(AND(G3:G17="Contract",F3:F17="Steven Jones"),($H7/$I7)*AND(G21>=$M7,G21<$M7+$I7),0)

You may also share your file for more relevant and suitable formula.

Thanks

Tauqeer