| 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 | |
| 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 |