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

Stumped

Excel Help for Stumped in Presenting and Reporting Data


Forum TopicPost Reply Login

Stumped

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
 duacandice
 Posted by on
 
Replies - Displaying 1 to 1 of 1Order Replies By: Most Recent | Chronological | Highest Rated
Confused
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:
 ABC
1  180 
2  =(B1+B1)/1000 
3   
That should do what you want...I guess. It's hard to tell for sure without any context behind what you're doing.

~Shiv 
 Posted by on
 Displaying page 1 of 1 

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