Stumped

Excel Help for Stumped in Presenting and Reporting Data

Stumped

Rate this: (3/5 from 1 vote)

	How 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 duacandice on 15 Feb 2007

Replies - Displaying 1 to 1 of 1

Order Replies By: Most Recent | Chronological | Highest Rated

	Stumped 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:   A B C 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 shiv_379 on 10 Apr 2007

Displaying page 1 of 1