Percentage point difference number format

J

jane

I have doing a simple calculation for the difference between columns with
%'s. I need to be able to have my result shouw as whole numbers.

ie

col 1 col 2 result
4% 2% 2% points - want thisis show as 2 (without a % sign)

thanks in advance.....jane
 
G

Glenn

jane said:
I have doing a simple calculation for the difference between columns with
%'s. I need to be able to have my result shouw as whole numbers.

ie

col 1 col 2 result
4% 2% 2% points - want thisis show as 2 (without a % sign)

thanks in advance.....jane
Click to expand...


=(A1-B1)*100
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Compare two different workbook sheet to show the difference in text 0
tiny discrepancies in fixed-point numbers 3
Show Difference as a Percentage 1
Date/time difference 6
Counting cells with SUMPRODUCT and conditionals...? 1
PT Sum of Difference 2
Scoring rank change and corresponding point difference 0
Need some help 2

Top