View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Mike B Mike B is offline
external usenet poster
 
Posts: 55
Default Macro for a comparison

Hello,

I would like the code for the following:

Compare the numbers in column I to column J (column I will always be a
bigger number). Display the result in column K in a percentage off high
(meaning column I) Its ok to display like: -7, no need to put the % sign.

example 49.35 is column I, 47 is column J column K should read -5, meaning
47 is 5% away from 49.35 and just display it as -5

Thanks in advance
--
Mike B