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 long-winded 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

Answerbag | Terms of Service | Privacy Policy