Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
row comparison | Excel Worksheet Functions | |||
Price Comparison Macro - This Is For An Excel MVP | Excel Discussion (Misc queries) | |||
Comparison | Excel Worksheet Functions | |||
HELP 2sht comparison MACRO | Excel Discussion (Misc queries) | |||
Comparison | Excel Programming |