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