I use windows 7 excel 2007
In column/cell " T31" I have inputed this formula
=IF(Q31="","",S31-N31)
In cell T31 If S31 = zero the formula returns the N31 value. I would like T31 to refelct zero when S31 is zero, then if S31 recieves a value greater than 0.00% then I want cell T31 to calculate S31-N31
I have tried in cell T31 =IF(Q31="","",IF(N(N31),S31-N31,0)) and =IF(OR(Q31="",N31=0),"",S31-N31)
They both return the value of N31
How can I change this formula?
Thank you for the help
In column/cell " T31" I have inputed this formula
=IF(Q31="","",S31-N31)
In cell T31 If S31 = zero the formula returns the N31 value. I would like T31 to refelct zero when S31 is zero, then if S31 recieves a value greater than 0.00% then I want cell T31 to calculate S31-N31
I have tried in cell T31 =IF(Q31="","",IF(N(N31),S31-N31,0)) and =IF(OR(Q31="",N31=0),"",S31-N31)
They both return the value of N31
How can I change this formula?
Thank you for the help
