How to: If D4 = Yes then Calculate C4/11, if D4 = no leave blank

  • Thread starter Thread starter Nate
  • Start date Start date
N

Nate

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
 
Create a Data validation list in D4 with source TRUE,FALSE
and enter in E4:
=IF(D4,C4/11,"")

Regards,
Stefi

„Nate†ezt írta:
 
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.
 
I'm translating back screen scripts to English therefore they may differ from
those you see on your screen!
Select the cell you want to create DV list for!
Data>Validation>Select List option from Allowed drop down list (the upper one)
Enter allowed values in Source field! If you want to allow a list of
constant values (like TRUE and FALSE in your case), enter them separated by
list separator set in your Windows Regional settings (comma in English
version, semicolon in some national language versions).
If you have allowed values in a range of cells, e.g. cells A1 contains TRUE
and A2 contains FALSE) then enter range reference in Source field: A1:A2 (You
can do that also by selecting the range with mouse).
Hope this helps!

Regards,
Stefi

„Nate†ezt írta:
 
Back
Top