IF AND NOT ISBLANK ISBLANK and do a sum if conditions are met - meltdown

[Dave01]

Hi everyone, I'm working on a depreciation spreadsheet, and Im usually really good at formulas, but I just cant get this one to work. Some reason I cant paste pictures, so Im going to write out my excel layout, hope it makes sense, the formula goes in Column I

The formula applies to Row 10


Columns

E F G H I J M 0

Purchase Cost	Periods to be Depreciated by	Depreciation %	Dep Chg in Months Applied	Dep chg For Current year	B/fwd			C/F		B/fwd
£708.00	60	25%	12	(FORMULA)	£708.00	-	-	708.00		511.99

<tbody>
</tbody>

This is my current formula -

=IF(AND(F10="",G10=""),"Error",IF(AND(F10="",NOT(ISBLANK(G10))),J10-O10)*0.25),IF(AND(G10="",NOT(ISBLANK(F10))),J10/F10)*H10))




So this is how it is supposed to work.

IF columns F & G are not blank this returns an Error.
If columns F10 is blank, but column G10 has a value (as a %) then it will do the calculation, 708 - 511.99 x 25%. The answer should be £49.
If columns F10 is has a value, but column G10 has a blank then it will do the calculation 708 / 60 * 12. This should be 142.


The formula as is posted, wont even execute because of the brackets here *0.25) and here *H10))


This does work

IF(AND(F10="",G10=""),"Error",IF(AND(F10="",NOT(ISBLANK(G10))),J10-O10)*0.25) - and gives me the answer of 49.

but as soon as I introduce the last bit - IF(AND(G10="",NOT(ISBLANK(F10))),J10/F10)*H10 for the 60 periods, it will give a result of 0.00 with the 25% still in there without the 60 entered. Removing the 25% and entering 60 in column F10 will also give a 0.00 result.


I do want it to go one step further and depending on the method - Reducing or fixed at a standard rate, by entering a R or F, but I need to get the above working done first

I really would appreciate some help to get this working as is should.

Many thanks

Dave.

 

[jtakw]

You're welcome, have a great weekend.