Ask Your Question

MG312's profile - activity

2020-10-29 23:47:55 +0100 marked best answer calc prints false when cell empty in screen view - SOLVED

Hi, hoping someone can shed some light on this, please.

I have a Till reconciliation which alerts staff if the till is up or down. The cell calculates if there is a non-zero result and shows "Up" or "Down" if there is a discrepancy between actual and expected values.

The formula is: =IF(C24<0,"DOWN",IF(C24>0,"UP")). Cell C24 contains the formula =ROUND(C23-C22,2). C22 and C23 both contain values entered in pounds and pence.

There are no divisions or multiplications in any of the cells in this sheet.

When using the sheet it shows an empty cell, which is what I want, but on Print Preview and also when the sheet is printed it shows "False", even if the value is zero.

Is there a way to print a blank cell?

2020-10-03 16:00:43 +0100 marked best answer Conditional formatting with different cells

Hi,

I am modifying our daily till reconciliation sheet to clearly show whether our till is up or down. This has become necessary due to errors being made......

I've worked out how to show this, but as you can see it then shows the rest of the week as Till Down in row 17 (or to be pedantic the rest of the week would show the most recent days resulting discrepancy). What I am aiming for is row 17 not to show anything until the till values are entered for that day.

My formula for row 17 cells is =IF(C16<0,"Till DOWN",IF(C16>0,"Till UP"))

(Row 11 brings forward the previous days float figure to help eliminate input errors)

Is there a way to do this? I would be very grateful for any help offered.

Hopefully you can find a link to an image of my spreadsheet here: https://s5.postimg.org/55inmn2qv/Libr...

2020-10-03 15:59:46 +0100 received badge  Famous Question (source)
2020-09-26 11:59:48 +0100 received badge  Famous Question (source)
2019-07-24 18:40:47 +0100 received badge  Notable Question (source)
2018-05-16 00:09:42 +0100 received badge  Famous Question (source)
2018-03-17 14:24:33 +0100 received badge  Notable Question (source)
2018-03-16 19:55:09 +0100 received badge  Popular Question (source)
2018-03-16 12:50:53 +0100 commented answer Change default font in calc

Thank you.

2018-03-16 12:50:10 +0100 commented answer Change default font in calc

Great. It's easy when you know where to look. I didn't realise that you could ask Calc to open a template as default. No

2018-03-16 11:23:54 +0100 received badge  Famous Question (source)
2018-03-16 10:27:50 +0100 asked a question Change default font in calc

Change default font in calc Hi, I know this question has come up before, but nothing works with the version I am using,

2018-03-13 18:24:10 +0100 edited question How to change default text box font in calc

How to change default text box font in calc I've Googled this but all the solutions I've found do not work. Every time

2018-03-13 18:23:29 +0100 commented answer How to change default text box font in calc

Hi Lupp Sorry I am unclear about this. If I click on delete it deletes your comment on my post. I did originally enter a

2018-03-13 18:22:54 +0100 commented answer How to change default text box font in calc

Thank you for your comprehensive and helpful reply. Now I know what I can and cannot do, and the workaround is certainly

2018-03-13 18:14:12 +0100 edited question How to change default text box font in calc

How to change default text box font in calc I've Googled this but all the solutions I've found do not work. Every time

2018-03-13 18:13:59 +0100 edited question How to change default text box font in calc

How to change default text box font in calc I've Googled this but all the solutions I've found do not work. Every time

2018-03-13 10:21:59 +0100 received badge  Notable Question (source)
2018-03-12 18:19:42 +0100 answered a question How to change default text box font in calc

Thanks, Peter, but that doesn't work. I don't have an option for Control. When I right click with the cursor flashing i

2018-03-12 18:17:38 +0100 commented answer How to change default text box font in calc

Thanks, Peter, but that doesn't work. I don't have an option for Control. When I right click with the cursor flashing i

2018-03-12 18:17:22 +0100 commented answer How to change default text box font in calc

Thanks, Peter, but that doesn't work. I don't have an option for Control. When I right click with the cursor flashing i

2018-03-12 18:06:17 +0100 received badge  Popular Question (source)
2018-03-10 17:23:57 +0100 received badge  Student (source)
2018-03-10 12:34:36 +0100 asked a question How to change default text box font in calc

How to change default text box font in calc I've Googled this but all the solutions I've found do not work. Every time

2018-02-13 15:17:47 +0100 received badge  Notable Question (source)
2018-02-12 16:25:37 +0100 received badge  Popular Question (source)
2018-02-12 15:02:40 +0100 edited question calc prints false when cell empty in screen view - SOLVED

calc prints false when cell empty in screen view Hi, hoping someone can shed some light on this, please. I have a Till

2018-02-12 15:01:40 +0100 commented answer calc prints false when cell empty in screen view - SOLVED

Thanks Mike, you've solved my problem!

2018-02-12 12:36:40 +0100 received badge  Famous Question (source)
2018-02-12 12:23:17 +0100 asked a question calc prints false when cell empty in screen view - SOLVED

calc prints false when cell empty in screen view Hi, hoping someone can shed some light on this, please. I have a Till

2017-05-20 13:29:22 +0100 edited question Conditional cell protection - SOLVED

Conditional cell protection Hi I put together a spreadsheet, with access by multiple users, with one cell that on certa

2017-05-20 13:29:07 +0100 marked best answer Conditional cell protection - SOLVED

Hi

I put together a spreadsheet, with access by multiple users, with one cell that on certain occasions users may legitimately need to enter a value into. This would overwrite the formula, and to allow this, the cell is unprotected. I want to stop users accidentally changing this cell when they are not supposed to.

Is there a way to protect a cell, but allow users to change the contents provided they are fully aware they are doing it and are correct to change it?

I was thinking of something along the lines of a message that flags up such as "Are you sure?"

Any help gratefully appreciated

2017-05-20 13:29:07 +0100 received badge  Scholar (source)
2017-05-20 13:28:47 +0100 answered a question Conditional cell protection - SOLVED

Thanks, that is really helpful!

2017-05-16 02:24:43 +0100 received badge  Notable Question (source)
2017-05-15 17:05:11 +0100 received badge  Popular Question (source)
2017-05-15 11:31:16 +0100 asked a question Conditional cell protection - SOLVED

Conditional cell protection Hi I put together a spreadsheet, with access by multiple users, with one cell that on certa

2017-05-06 23:15:32 +0100 received badge  Popular Question (source)
2017-05-02 18:25:49 +0100 edited question Conditional formatting with different cells

Conditional formatting with different cells Hi, I am modifying our daily till reconciliation sheet to clearly show whet

2017-05-02 18:25:49 +0100 received badge  Editor (source)
2017-05-02 18:22:13 +0100 edited question Conditional formatting with different cells

Conditional formatting with different cells Hi, I am modifying our daily till reconciliation sheet to clearly show whet

2017-05-02 18:19:54 +0100 asked a question Conditional formatting with different cells

Conditional formatting with different cells Hi, I am modifying our daily till reconciliation sheet to clearly show whet