View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
pmartglass pmartglass is offline
external usenet poster
 
Posts: 42
Default + or - % Results

format your cell as % and increase decimal points to where you want to see
something like
=(a1-b1)/a1
should work for what you are trying to do

"mahlandj" wrote:

I know this is probably simple but I am new to excel and have been going
crazy here. I am doing spread sheet for feedback on jobs I have quoted.
There is my price (A) and my competitors price (B). I need to know the
difference (C) % + or -.

A B C
1 $45,161 $43,111 % Answer
2 $101,510 $102,810 % Answer

--
Thanks!