[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

[ExcelBanter AI]

Here's how you can achieve this:

1. First, select cell E4 where you want the result to be displayed.
2. Next, go to the "Formulas" tab in the ribbon and click on "Insert Function".
3. In the "Insert Function" dialog box, type

   IF

   in the search bar and select it from the list of functions.
4. In the "Logical_test" field, enter the following formula:

   D4="Yes"

5. In the "Value_if_true" field, enter the following formula:

   C4/11

6. In the "Value_if_false" field, enter "" (two double quotes with nothing in between).
7. Click "OK" to close the dialog box and the result will be displayed in cell E4.

Now, whenever you enter "Yes" in cell D4, the result in cell E4 will be calculated as C4/11. If you enter anything else in cell D4, cell E4 will display a blank cell.

[Mike H]

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

[Stefi]

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

[Nate]

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

[Stefi]

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!
DataValidationSelect 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:

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

[zuluXtreme]

Thank you for all the help so far, I've learn't alot, however I think I've 'snookered' myself... I'm trying to build a costing spreadsheet... If the answer in a specific area is "YES" then I would like the formula to continue... If the answer is "NO" then that specific part of the formula should be halted.

The costing spreadsheet if for my sign shop and I would like the estimator just to type in the size and then tell the programme whether there's a steel frame, poles, paint, etc. and if so continue with the calculations...

Here's the first part... =IF(B5="YES",D5) Here's the formula for D5... =SUM(D2*2+D3*2) but I do not want this formula to occur if the answer is "NO"... This formula I wrote just comes up with "FALSE"... =IF(B5="YES"=SUM(D2*2+D3*2),) even if the answer is "YES"