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.

 

[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]

It worked! Thank you soooo much!!!

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.