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
[TABLE="width: 851"]
<tbody>[TR]
[TD]Purchase Cost[/TD]
[TD]Periods to be Depreciated by[/TD]
[TD]Depreciation %[/TD]
[TD]Dep Chg in Months Applied[/TD]
[TD]Dep chg For Current year [/TD]
[TD] B/fwd[/TD]
[TD][/TD]
[TD][/TD]
[TD]C/F[/TD]
[TD][/TD]
[TD]B/fwd[/TD]
[/TR]
[TR]
[TD]£708.00[/TD]
[TD]60[/TD]
[TD]25%[/TD]
[TD]12[/TD]
[TD](FORMULA)[/TD]
[TD] £708.00[/TD]
[TD] -[/TD]
[TD] -[/TD]
[TD] 708.00[/TD]
[TD][/TD]
[TD] 511.99[/TD]
[/TR]
</tbody>[/TABLE]

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.