View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
RagDyeR
 
Posts: n/a
Default 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