Change one cell based on the values of two cells

**jonathanchacon** · 09-22-2011, 01:24 PM

Hello, I am trying to make one cell post a dollar amount based on the information from two cells. the code I am using now is =IF(D17="Dependent",AND(H9="1AY")) in the cell I have that code it gives me a value of TRUE, but I want it to give me the value of $3,500.00. Then I need to be able to change that $3,500.00 to $4,500.00 if H9="2AY", any help is greatly appreciated. This has been giving me a headache for a while now.

**Marcol** · 09-22-2011, 01:28 PM

The syntax is
=IF(AND(D17="Dependent",H9="1AY"),3500,"")

Use the built in help to understand formula.
Put the cursor in the formula bar within the formula you wish to use then click the fx button to the left.
Then click Help on this function

**sivdin** · 09-23-2011, 05:35 AM

Hi,

Thanks, I have a similar requirement with more combinations.

Like, if two cell values are 'x' and 'y' the target cell value should become "john", in case of other combinations, the same target cell value should become as "peter".

I would like to know how do we embed these as codes in the worksheet? or in a module? because I don't need these to be in formula tab as is it is not protected.I require this as an automatic update without using any button or userform.

Hope my requirement is clear. Can anyone help me on this?

**arthurbr** · 09-23-2011, 06:30 AM

Sivdin

Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread.