software

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=quot;:30quot;,35,IF(D1=quot;:60quot;, 50,IF(D1=quot;:90quot;,75,quot;quot;)))
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.

quot;laughingbirdquot; wrote:

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

There's several ways to do this, the best selection of which depends on how
many choices you have.......if only a few, then quot;IFquot;, or quot;LOOKUPquot; would
probably be better, if many choices, then quot;VLOOKUPquot; would probably be
better........

Vaya con Dios,
Chuck, CABGx3
quot;laughingbirdquot; wrote:

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

It worked! Thank you soooo much!!!

quot;SVCquot; wrote:

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