I have a spreadsheet which I need to modify a bit with a much more complicated formula. Hoping someone can advise.
Here's the existing formula in C2.
<tbody>
Classification
Revenue
Jan
Feb
Mar
Apr
Conv Date
New Business
$500K
if(ConvDate>C1,0,B2/12)
Jan 15
Upsells
$1M
Feb...