View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
joeu2004 joeu2004 is offline
external usenet poster
 
Posts: 2,059
Default Nesting IF/calculate percentage

On Apr 9, 3:14 pm, JN wrote:
Could anyone help me with a formula that would compare Col B & Col C and
return the information in Col D?
Col B Col C Col D
950.91 950.91 0%
0 0 0
0 330.41 100%
1.96 11.05 463.8%


In D1 and copy down:

=if(B1=0, 100%, C1/B1 -1)

Format the cell as Percentage with the desired number of decimal
places.

Not everyone would agree that if B1 is zero, 100% is the right
answer. But that is what you asked for.