Struggling with a checkbox issue on my form

Good afternoon everyone.

I'm currently building a new order form using Excel at work and I have a front sheet which has three cells, each with a checkbox.
Each tab corresponds to a tab on the form - each for different products. If the customer enters any value into a cell within specified ranges on one of the tabs, the frontsheet has a formula in which tells it to check the box to show order entry which tab has had information added.


The issue I'm having is that some of the selections on the tabs are checkboxes and I've noticed that if the customer ticks a box and then unchecks it, it leaves FALSE in the linked cell and the checkbox on the front sheet thinks that this is customer input so remains checked.

How do I stop Excel from displaying either TRUE or FALSE in the linked cell, thereby not providing my checkboxes on the front with spurious data? I want the customer to be able to tick the boxes where appropriate to select the correct product configuration they require but if they then uncheck the box because they ticked it by mistake, I want it to not affect the =IF(OR(NOT(ISBLANK formula on the front page.

1.png2.png

Hi, so the full formula for the front page is:

=IF(OR(NOT(ISBLANK('INTERNAL'!A31:P39)),NOT(ISBLANK('INTERNAL'!A52:P59)),NOT(ISBLANK('INTERNAL'!A72:P79)),TRUE,FALSE)

The A32:P39 refers to a fillable table - same with A52:P59.
A72:P79 contains two columns of check boxes with options for configuring the product the customer wants to order.

As mentioned previously, if the customer for example is trying to order an internal product and they fill in the table - everything works fine.
If they however check one of the boxes in the range above and then for whatever reason uncheck the box - perhaps changing their mind about certain aspects of the product configuration
it returns a FALSE value in text in the cell linked to the checkbox in question and this causes the front sheet checkbox to remain ticked as it treats this FALSE text as a value the customer has entered.

I can't add any further columns etc as we have the formatting of columns and rows in place - I just need to ascertain if there's a way of preventing Excel from displaying the TRUE or FALSE values, causing this incorrect reporting on the front sheet.

For reference, the front sheet will work as a guide for our order entry staff - they know which sheet to go to for the customer information. It's only two tabs at present but we are looking to expand the form to encompass maybe up to 10 tabs for different product types.

Hope this explains what I'm trying to do.

Thanks
Rich