formula

[Vic Abrahamian]

Hi,
Would anyone know what the formula should be for this below
=sum(a1+a2)/abs(a1)
If I want to use a conditional statement
If a1=0 need the result to be 100%,
but if A1 is any number other than 0 I need the formula above to work as it
should.
Thank you

 

[Rick Rothstein \(MVP - VB\)]

Try this...

=IF(A1=0,100,SUM(A1+A2)/ABS(A1))

I'm not sure if the 100 should be 100% or 1... it depends on how you are
making the cell show the percentage.

Rick

 

[Vic Abrahamian]

Shouldn't there be a If Not statement too? what if A1 changes to a different
number?
Thank you

 

[Rick Rothstein \(MVP - VB\)]

I'm not sure I'm following your question... the IF function I gave you
handles both the True and the False condition. It will return 100 if A1 = 0,
otherwise (for any other value in A1) it will return whatever
SUM(A1+A2)/ABS(A1) evaluates to. Isn't that what you asked for?

Rick

 

[Vic Abrahamian]

Hi, I'm sorry.
Here is in an example
A1=0
B1=9600
C1=sum(A1-b1) which equals (-9600)
With the formula =(IF(A1=0,100,SUM(A1+B1)/ABS(A1))), I get 100
If I change the number to 2 I get 4801, is that correct?
If I change the number to -2 I get 4799

 

[Rick Rothstein \(MVP - VB\)]

Well, I don't know if that is correct or not... it is **your** formula (the
SUM divided by the ABS part), not mine. Also, you gave SUM(A1+A2) in your
first post, but you are showing SUM(A1-B1) in your example (I'm more
concerned with the switch from plus to minus than in the cell reference
change), so I'm not sure what formula you really want. Also, I should have
noted in my first response that you do not need the SUM function call at
all...

SUM(A1+B1) is the same as (A1+B1)

and

SUM(A1-B1) is the same as (A1-B1)

Rick