Can I build special codes in a speadsheet that calculate
If you just want to give a value to a string (8V - 8FH), you can create
what's called a "named formula".
There are however, some reservations on exactly what strings (names) are
acceptable to XL.
These worked for me:
VAC8
FLH8
Start with:
<Insert <Name <Define,
In the "Names In Workbook" box, enter
VAC8
At the bottom, *change* whatever is in the "RefersTo" box to:
=8
Click <Add
Again, in the "Names In Workbook" box, enter
FLH8
=8 should *still* be displayed in the "RefersTo" box,
So just hit <OK.
Now, if you enter
=vac8
OR
=flh8
in any cell, you'll get 8.
So, you can now have formulas such as:
=A1+vac8
OR
=SUM(A1:D1,flh8)
OR
=vac8+flh8
--
HTH,
RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===
"wireed!" wrote in message
...
I want to us 8 V for 8 hours vacation or 8 hours fh for 8 hour floatin
holiday.
I'm sure some one has done it just I can't find it
|