I would just use a helper cell and subtract 1 from the linked cell.



Whois Clinton wrote:

Hi,

I have several groups of of Option Buttons from the "Forms" toolbar on a
worksheet. Currently each group is linked to a cell and reports a numeric
value (1-5) in that cell. The values denote a scale which I want the values
to rank 0-4 instead of 1-5. Is there a way to make this change in output so
that the number results come out 0-4 instead of 1-5.

TIA,
Clint

--

Dave Peterson