How do I assign dollar value to text

[laughingbird]

I am putting together an invoice spreadsheet for Voice Overs. I want to be
able to type :30 in Column D and have the value of $35 to appear in Column F.
Subsequently, If I type :60 in Column D the value of $50 will appear in
Column F, and :90 equals $75 and so on. How do I assign values to these
text/column entries?

Thank you,
Laughingbird

[SVC]

Try this formula in F1: =IF(D1=":30",35,IF(D1=":60", 50,IF(D1=":90",75,"")))
and format the cell (or column) as currency. Copy down as far as necessary.
If anything but the three values is entered in D, the cell will be left blank.

"laughingbird" wrote:

> I am putting together an invoice spreadsheet for Voice Overs. I want to be
> able to type :30 in Column D and have the value of $35 to appear in Column F.
> Subsequently, If I type :60 in Column D the value of $50 will appear in
> Column F, and :90 equals $75 and so on. How do I assign values to these
> text/column entries?
>
> Thank you,
> Laughingbird

[CLR]

There's several ways to do this, the best selection of which depends on how
many choices you have.......if only a few, then "IF", or "LOOKUP" would
probably be better, if many choices, then "VLOOKUP" would probably be
better........

Vaya con Dios,
Chuck, CABGx3



"laughingbird" wrote:

> I am putting together an invoice spreadsheet for Voice Overs. I want to be
> able to type :30 in Column D and have the value of $35 to appear in Column F.
> Subsequently, If I type :60 in Column D the value of $50 will appear in
> Column F, and :90 equals $75 and so on. How do I assign values to these
> text/column entries?
>
> Thank you,
> Laughingbird

[laughingbird]

It worked! Thank you soooo much!!!

"SVC" wrote:

> Try this formula in F1: =IF(D1=":30",35,IF(D1=":60", 50,IF(D1=":90",75,"")))
> and format the cell (or column) as currency. Copy down as far as necessary.
> If anything but the three values is entered in D, the cell will be left blank.
>
> "laughingbird" wrote:
>
> > I am putting together an invoice spreadsheet for Voice Overs. I want to be
> > able to type :30 in Column D and have the value of $35 to appear in Column F.
> > Subsequently, If I type :60 in Column D the value of $50 will appear in
> > Column F, and :90 equals $75 and so on. How do I assign values to these
> > text/column entries?
> >
> > Thank you,
> > Laughingbird