software

Chauffer Yes / NoPriceTotal
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.


You could use this formula,

=IF(B1=quot;Yesquot;,65,0)

format your cell for currency--
davesexcel
------------------------------------------------------------------------
davesexcel's Profile: www.excelforum.com/member.php...oamp;userid=31708
View this thread: www.excelforum.com/showthread...hreadid=522948THANK YOU

quot;davesexcelquot; wrote:

gt;
gt; You could use this formula,
gt;
gt; =IF(B1=quot;Yesquot;,65,0)
gt;
gt; format your cell for currency
gt;
gt;
gt; --
gt; davesexcel
gt; ------------------------------------------------------------------------
gt; davesexcel's Profile: www.excelforum.com/member.php...oamp;userid=31708
gt; View this thread: www.excelforum.com/showthread...hreadid=522948
gt;
gt;