Hi,

Try this

=IF(D4="Yes",C4/11,"")

Mike

"Nate" wrote:

Hi everyone,

Basically I am making a purchases journal on excel and I want to be able to
click a check box or just type in Y/N and if the box is checked or it is 'Y'
then excel will divide the price by 11 and display in say E4.
If the box is unchecked, it displays blank or N/A or something to that
effect.

Thankyou