Thanks for the replies everyone.

Stefi, if you don't mind, could you please walk me though the data
validation list.
I have tried this step and I am finding the list wizard a little confusing,
namely: where the data is on my list and setting the source as TRUE,FALSE
thanks.



"Stefi" wrote:

Create a Data validation list in D4 with source TRUE,FALSE
and enter in E4:
=IF(D4,C4/11,"")

Regards,
Stefi

€žNate€� ezt Ã*rta:

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