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.
IF(AND(g3:g17, "Contract", f3:f17, "Steven Jones"), Then perform a formula on this cell valueThis 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.
Try below formula:
You may also share your file for more relevant and suitable formula.