Home > Forum Home > Presenting and Reporting Data > Stumped Share


Excel Help for Stumped in Presenting and Reporting Data

Forum TopicPost Reply Login


Rate this:
(3/5 from 1 vote)
ConfusedHow do i get excel to calculate the following?

180 (+) 180 (=) 0.36

however i do not want imput the data as 0.18 but as 180
what is the formula i use??
please help
 Posted by on
Replies - Displaying 1 to 1 of 1Order Replies By: Most recent | Chronological | Highest Rated
Rate this:
(3/5 from 1 vote)
You could simply do the addition the divide the result by 1000. So if your "180" was in cell B1, "=(B1+B1)/1000"
Excel Spreadsheet:
1  180 
2  =(B1+B1)/1000 
That should do what you want...I guess. It's hard to tell for sure without any context behind what you're doing.

 Posted by on
 Displaying page 1 of 1 

Find relevant Excel templates and add-ins for Stumped in the