formula query

[mart_mrexcel]

I have acciden Unit measure of +/- .25. If my result is .25 my %score point is 100, if my result point is decreasing my %scorepoint should increase too. Can someone help me with the formula thanks

 

[tyija1995]

Hey,

so if your measure can be +.25 or -.25 you want to see 100% in the cell with the formula? Is that right?

=4*ABS(A1)
Where A1 is the accident unit measure.
Then format as a %

 

[mart_mrexcel]

Hey,

so if your measure can be +.25 or -.25 you want to see 100% in the cell with the formula? Is that right?

=4*ABS(A1)
Where A1 is the accident unit measure.
Then format as a %

Yes u are correct my measure can be +.25 or -.25. If .25 then 100%. Sir what is 4 in the formula 4*ABS(A1)? and is the A1 the result or the uom?

 

[tyija1995]

The 4 translates .25 to a 1, which formatted as % is 100%, I used ABS as you said you want the %scorepoint to increase if the result point is decreasing, A1 is the cell that contains the uom, so put formula in another cell.