How do I assign dollar value to text

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 
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
 
It worked! Thank you soooo much!!!

SVC said:
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.
Click to expand...
 
Back
Top