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
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
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!" <[email protected]> wrote in message
news:[email protected]...
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
Created fine, but when I enter the vac8 or flh8, I get enter value between 0
- 24?
Imust not be doing something correctly?
"RagDyeR" wrote:
> 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!" <[email protected]> wrote in message
> news:[email protected]...
> 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
>
>
>
When you enter them where? ... how?
Where do you see the error message?
Go to
<Insert> <Name> <Define>
Do you see both strings displayed in the big window?
If so, click on one of them.
Do you see
=8
in the "Refers To" box?
If so, do the same with the other string.
Does that also display
=8
?
--
Regards,
RD
---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"wireed!" <[email protected]> wrote in message
news:[email protected]...
> Created fine, but when I enter the vac8 or flh8, I get enter value between
0
> - 24?
>
> Imust not be doing something correctly?
>
> "RagDyeR" wrote:
>
> > 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!" <[email protected]> wrote in message
> > news:[email protected]...
> > 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
> >
> >
> >
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks