Quote:
Originally Posted by steve.
how can i create a formula that does this? 0.5 plus or minus 1% where the 0.5 could be entered as a input figure / number (result for this example should read equal 0.51 - 0.49 rounding up or down)
|
Dear Steve, Good Morning.
Suppose your data is on A1.
Do B1 -- =A1+(0,01)&" - "&A1-(0,01)