by 
sci-geek
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.
RELATED QUESTIONS
Copyright 2023, Wired Ivy, LLC