Thread: formula
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Vic Abrahamian Vic Abrahamian is offline
external usenet poster
 
Posts: 12
Default formula

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