View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
[email protected] forestwalker@gmail.com is offline
external usenet poster
 
Posts: 3
Default Helo there - Help with showing deviation (+/-) from a set number...

I am attempting to set one cell (R6C20) as a value, a second cell
(R9C20) as a number and then have a third cell (R12C20) display the
deviation of (R6C20) from (R6C20).

I want to show by how much something has gone over or under an
allocation. I would like the value in (R12C20) to display as a
negative is it is under, all in whole numbers with no decimals.

Thanks in advance,
Forest