ExcelBanter - How do I have a word be associated with a price?

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - How do I have a word be associated with a price? (https://www.excelbanter.com/excel-discussion-misc-queries/77632-how-do-i-have-word-associated-price.html)

How do I have a word be associated with a price?

Chauffer Yes / No Price Total
Monday, April 02, 2007 $65.00
Tuesday, April 03, 2007
Wednesday, April 04, 2007

If a Person selects yes I would like for the total of $65.00 show up under
TOTAL column. If NO is selected the $0.00 would show up.

davesexcel

How do I have a word be associated with a price?

You could use this formula,

=IF(B1="Yes",65,0)

format your cell for currency

--
davesexcel
------------------------------------------------------------------------
davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708
View this thread: http://www.excelforum.com/showthread...hreadid=522948

How do I have a word be associated with a price?

THANK YOU

"davesexcel" wrote:

You could use this formula,

=IF(B1="Yes",65,0)

format your cell for currency

--
davesexcel
------------------------------------------------------------------------
davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708
View this thread: http://www.excelforum.com/showthread...hreadid=522948

All times are GMT +1. The time now is 01:02 AM.