Thread: formula
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Rick Rothstein \(MVP - VB\)[_1899_] Rick Rothstein \(MVP - VB\)[_1899_] is offline
external usenet poster
 
Posts: 1
Default formula

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" wrote in message
...
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