For example In D30 this formula

=IF($B$15="yes",F30,0)


--
Regards Ron de Bruin
http://www.rondebruin.nl



"troy stud" wrote in message ...
How do you do formula's, calculations? If the condition in b15 is yes, then
the value in column d would change to whatever is in column F. If the
condition is no, then there would be a 0? I'm unfamiliar with doing formula's.
Thanx