ANSWERS: 5

You know, I've found that I've never had to type anything more complicated than a FOIL equation.

This is probably as longwinded as anything else I've ever typed into Excel: =IF(OR(I8<=$D$3,NOW()<$D$3),F8)+IF(AND(NOW()>$D$3,NOW()<$D$5,I8>$D$3),ROUND((H8*(NOW()$D$3)/30*2%)+F8,0))+IF(I8>$D$3,ROUND(H8*(I8$D$3)/30*2%,0)+F8)+IF(AND(NOW()>$D$5,I8=0),ROUND((H8*14%)+(F8*14%),0))+IF(AND(NOW()>$D$3,I8=0),ROUND((H8*(NOW()$D$3)/30*2%)+F8,0))

Something hideous using IF statements coupled with array summations and rounding probably. I don't know exactly to be fair, I have done some pretty horrendous Excel formulae in my time!

I've done some hellacious combinations of SUMPRODUCT formulas. That is, adding one SUMPRODUCT to another based on various values in the worksheet. I wouldn't even attempt to recreate it here.

I don't remember exactly, but there were some ridiculously long formulas in my Computer Skills for Engineers class.
Copyright 2018, Wired Ivy, LLC