Helo there - Help with showing deviation (+/-) from a set number...

F

forestwalker

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
 
F

forestwalker

I am a mooooron. =R9C20-R6C20

Will show a smaller actual number than the allocation as a neg (i.e. x
number below allocation) and a higher as a positive...

yay
 

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

Problem with SET & REF function 0
Creating a Chart on form from selected data in query. 0
Mail Merge - displaying a conditional number of decimals 5
Help needed! Extracting Heading 3 and Contents from a Word Doc to Excel 0
How to use "standard deviation" option in Y error bar menu? 1
How to retrieve number of visible digits after decimal point in VBA 8
how to write function to find max deviation from specific number . 2
Multiply with Vlookup value from another Worksheet 0

Top