Excel Yes/No Two Different $ amounts 1

[mcaoneill]

Good Morning,

I need excel to input into one column a dollar amount which depends on the input from another column.

Column D is Yes or No, if it is yes, column E would have $2,000.00 and if Column D is No column E would have $415.00.

Any help is GREATLY appreciated.

Thank you

Maureen

 

[TonyJollans]

Hi Maureen,

If there's nothing more to it ..

[blue][tt]=IF(D1="Yes",2000,415)[/tt][/blue]

.. formatted as Currency

Enjoy,
Tony

--------------------------------------------------------------------------------------------
We want to help you; help us to do it by reading this: Before you ask a question.

 

[mcaoneill]

Marry Me??

Thank you very much
Have a great day

 

[TonyJollans]

Already married I'm afraid - mind you, that didn't stop me before

Enjoy,
Tony

--------------------------------------------------------------------------------------------
We want to help you; help us to do it by reading this: Before you ask a question.