I am looking for a formula IF 1 cell says...

November 21, 2011 at 13:57:00
Specs: Windows 7
I am looking for a formula that states. If A4=Data, then G4=$amt. I have read variations of this Q&A but I have not found a solution yet. thanks for any help

See More: I am looking for a formula IF 1 cell says...

Report •


#1
November 21, 2011 at 16:21:49
Your question is not clear.

Are Data and $amt text strings? If so, enter this in G4:

=IF(A1="Data", "$amt", "")

G4 will display the text string $amt is A1 contains the word Data, otherwise it will be blank.

If Data and $amt represent something else, you'll need to explain that to us.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •

#2
November 21, 2011 at 19:41:52
The "data" in cell A4 is letter and numbers (NV15). When that is plugged into cell A4 I would like for a specific cell (such as G4) to have a value such as $1.00. Does that explain it a little better? Thanks again for your help.

Report •

#3
November 21, 2011 at 19:50:09
No, your question is still not clear.

Since we have no idea about what you are trying to accomplish you have to be very specific.

Are you looking for a specific value to be placed into G4 based on what is in A1, i.e. you have a list of values that will be entered into A1 and you need a corresponding dollar amount to appear in G4?

Is it always G4 in which the dollar value should appear?

How many "matching sets" of Datas/$amts do you have?

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •

Related Solutions

#4
November 28, 2011 at 11:09:37
I apoligize for not getting back with you sooner.

Yes, I think you are understanding what I am asking for. A1 will have a drop down list and when a specific item fro example NV15 is selected, a corresponding amount will appear in G4. The amount will always appear in G4. I will have 4 items in the list for A1 and a corresponding amount will appear in G4 for each item.


Report •

#5
November 28, 2011 at 11:29:43
With 4 "pairs", you could use a Nested IF in G4:

=IF(A4="NV15", 1, IF(A4="XY27", 2, IF(A4= etc.

Format G4 as currency and the results will display as dollar values.

However, a more elegant solution would be to use VLOOKUP. Look it up in the Excel Help files.

Create a table of your pairs in e.g. B1:C4 and use something like:

=VLOOKUP(A4, $B$1:$C$4, 2, 0)

By using VLOOKUP you could simply change the table if your data or dollar values change and not have to edit the formula.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •

#6
November 28, 2011 at 14:00:41
Thank's so much for your help. I will try the Vlookup.

Report •


Ask Question