Calculating Formula

[jaxs2009]

I use windows 7 excel 2007

In column/cell " T31" I have inputed this formula

=IF(Q31="","",S31-N31)

If N31 = zero the formula returns the S31 value. I would like T31 to refelct zero when N31 is zero regardless of any value that maybe in S31.

How can I change this formula?

I have tried

=IF(Q31="","",IF(N(N31),S31-N31,0)))
and
=IF(OR(Q31="",N31=0),"",S31-N31)

Both are not working the way I want it to.

Jon von der Heyden a fellow memember gave me a solution in which I lost and in his formula I remember it had "LEN" as part of it.

Thank you for the help

 

[home_toast]

Is this what you're looking for?

=IF(Q31="","",IF(N31=0,0,S31-N31))

HTH

TJ

 

[Misca]

LEN returns the number of digits in the cell but I'd use the VALUE -function instead:

Try =IF(OR(Q31="",VALUE(N31)=0),"",S31-N31)

 

[Dryver14]

Following on from yesterday

=IF(N31=0,S31,IF(Q31="",0,S31-N31))

 

[jaxs2009]

Thank you for the input but the formula's being offered returns 0.00% in cell T31

Cell N31 will always have some percentage value at any given time, example 2.00%

Cell S31 is blank until a macro upon command will input a percentage value lets say 4.00%.

I will need cell T31 to calculate the difference - BUT - If cell S31 recieves a value of 0.00% via the macro then cell T31 needs to reflect 0.00%

I hopes this helps everyone who is trying to help.

jaxs

 

[home_toast]

If N31 = zero the formula returns the S31 value. I would like T31 to refelct zero when N31 is zero regardless of any value that maybe in S31.

That was why we offered the formula as they were.

=IF(Q31="","",IF(S31=0,0,S31-N31))

HTH

TJ

 

[Jon von der Heyden]

Here's the link to the original question, including the formula that I suggested:
http://www.mrexcel.com/forum/showthread.php?t=529743

For future reference, you can retrieve your old posts by viewing your subscriptions:

On the blue bar > Quick Links > Subscribed Threads

Or you can go to you user profile (by clicking on your username) and on the statistics menu you can (1) View posts by user or (2) View threads started by user.

 

[jaxs2009]

Tried to find it first prior to contacting you but could not find it, I will try to find it via your response.

Thank you

 

[jaxs2009]

Found it, again thank you,