How to: If D4 = Yes then Calculate C4/11, if D4 = no leave blank
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
|