My math always has been, well, crap! trying to get my head around this now, I think I'm about to explode!
Well drawdown calculator how to#
Still trying to figure out how to get this working, looking at SHG's original code as a starter, to try and work out the math. I might contact dropbox over thisī6: =IF(ISNUMBER(B2), B2, IF(ISNUMBER(B3), B3 * B1, IF(ISNUMBER(B4), (1 - B4) * B1, "")))īut now seeing as I've reconfigured my spreadsheet and added cells, moved cells etc I'm totally confused!! (& thanks again SHG for your reply earlier, very much appreciated as always!)Įdit, just to add, if you open in dropbox, for some reason dropbox shows the referenced cells differently on the web! You have to download it and you'll see the cell references are the same as the one's shown on the image Imgur. So hard to find something like this on the web. I know the formulas will be more difficult because of the cell 'I6' with the drop down selector, but it makes the whole sheet work well. I know it's a big ask, but if you / anyone can help getting this calculator working it would be really really fantastic, I don't think there is a way to do it with 64bit excel? If there is, I'm all ears!
I would have used (Excel Jeanie/HTML Maker), but I've got 64bit excel installed so I couldn't add it here, as they aren't 64bit compatible). I know from the screenshot it looks 'Busy' but that's because I spent time to include all the cell references. This then means that from this selection all the calculations will be either showing recovery data (To get back to break even), The main difference SHG is that I've managed to make Cell I6 a 'LIST' drop down menu where a user can select either 'GAIN' or 'LOSS' I include a dropbox excel sheet link here also
I've added 'callouts' to reference cell loctions. I've had a rethink SHG, as I made a few errors, saw ways to improve the calculator, and I've spent a few hrs redesigning a new version this morning.Īgain, trouble is I'm not clever enough with formulas to get it working! But I can design ok, well kind of.) Thanks again for your reply yesterday, I've recovered now!
0 kommentar(er)
