2 check if statement

[richy1066]

Hello all,

I'm trying to do a 2 check statement, and i nearly have it, but the last bit is beating me and i'm confused as to how tofix it.

my formula is:

=IF(Input!D5-Input!E5=0, ROUND((Input!E5/(Input!O2/100+1)),2),IF(Input!G5 =1,ROUND((Input!E5/(Input!O2/100+1)+Input!E5),2),0))

the 2 checks i need are:
1. Input!D5-Input!E5=0
2. Input!G5 =1

the first bit seems to be ok, if Input!D5-Input!E5=0 it does ROUND((Input!E5/(Input!O2/100+1)),2). If it doesnt = 0 it does ROUND((Input!E5/(Input!O2/100+1)+Input!E5

but the second criteria seems to be letting me down, if Input!G5 is blank it is still outputting a calculated value into the cell, not the 0 i want for a false result on the if.

hope the above makes sence. any help would be very very greatfully recieved.