help with a formula

Question

Total Projected Volume2022&nbsp; June&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;10% growth over June 20222022&nbsp; September$1 per case on all SKU' s&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; after 10% growth - payout increases to $2 per caseBEN GARFIELD&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; (329)701771293&nbsp;JEFFREY VINCENT&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; (500)448493190&nbsp;MICHAEL KOLB&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; (464)789868323&nbsp;MICHAEL KUSCHKA&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; (467)635699339&nbsp;RENE MORRISSETTE&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; (477)590649156&nbsp;

kathy2160 · Answer

Can't get a formula to work - $1 per case if Sept 2022 is &lt; 10% growth ($1 x 293)$2 per case if Sept 2022 is &gt;/= 10% growth ($2 x 293)

kathy2160 · Answer

Kathy2160&nbsp;&nbsp;

Forum Discussion

help with a formula

2 Replies

Total Projected Volume	2022 June	10% growth over June 2022	2022 September	$1 per case on all SKU' s after 10% growth - payout increases to $2 per case
BEN GARFIELD (329)	701	771	293
JEFFREY VINCENT (500)	448	493	190
MICHAEL KOLB (464)	789	868	323
MICHAEL KUSCHKA (467)	635	699	339
RENE MORRISSETTE (477)	590	649	156