질문하기

Inclement's profile - activity

2020-11-06 00:24:23 +0100 받은 배지  유명한 질문 (source)
2020-08-09 20:12:15 +0100 받은 배지  유명한 질문 (source)
2020-07-20 22:52:39 +0100 받은 배지  주목할 만한 질문 (source)
2020-04-19 15:32:05 +0100 받은 배지  유명한 질문 (source)
2020-04-19 15:32:05 +0100 받은 배지  주목할 만한 질문 (source)
2020-03-05 21:01:57 +0100 코멘트달린 답변 Conditional formatting for cells used in function

Oh hooray! I think Lupp's got it now, with the SUMIF() function! :)

2020-03-05 15:40:58 +0100 질문에 댓글을 달았습니다 Conditional formatting for cells used in function

Stan, are there two separate problems? Marking the items Calculating the total price of the marked items For (1), if

2020-03-05 15:40:42 +0100 질문에 댓글을 달았습니다 Conditional formatting for cells used in function

Stan, are there two separate problems? Marking the items Calculating the total price of the marked items For (1), if

2020-03-05 15:40:27 +0100 질문에 댓글을 달았습니다 Conditional formatting for cells used in function

Stan, are there two separate problems? Marking the items Calculating the total price of the marked items For (1), if

2020-03-05 15:26:01 +0100 질문에 댓글을 달았습니다 Conditional formatting for cells used in function

Stan, are there two separate problems? Marking the items Calculating the total price of the marked items For (1), if

2020-03-05 15:25:01 +0100 질문에 댓글을 달았습니다 Conditional formatting for cells used in function

Stan, are there two separate problems? Marking the items Calculating the total price of the marked items For (1), if

2020-03-05 15:23:37 +0100 질문에 댓글을 달았습니다 Conditional formatting for cells used in function

Stan, are there two separate problems? Marking the items Calculating the total price of the marked items For (1), if

2020-03-05 15:22:16 +0100 질문에 댓글을 달았습니다 Conditional formatting for cells used in function

Stani, are there two separate problems? Marking the items Calculating the total price of the marked items For (1), i

2020-03-05 15:21:21 +0100 질문에 댓글을 달았습니다 Conditional formatting for cells used in function

Stani, are there two separate problems? Marking the items Calculating the total price of the marked items For (1), i

2020-03-05 15:21:06 +0100 질문에 댓글을 달았습니다 Conditional formatting for cells used in function

Stani, are there two separate problems? Marking the items Calculating the total price of the marked items For (1), i

2020-03-04 15:51:11 +0100 코멘트달린 답변 How to change checkbox colors/style?

Thank you! I'm not familiar at all with macro code, so it'll take me a while to get through that.

2020-03-04 01:39:37 +0100 코멘트달린 답변 How to change checkbox colors/style?

Thank you! I'm not familiar at all with macro code, so it'll take me a while to get through that. (Any idea why the def

2020-03-04 01:19:39 +0100 으뜸 답변으로 표시됨 How to change checkbox colors/style?

Similar to here (it didn't get any answers).

I made some checkboxes on a spreadsheet - they work perfectly, but have a gold background. Is there a way to change that?

Tools > Options > Libreoffice > Application Colors doesn't have it, as far as I can tell.

Control Properties > General > Background color changes the background color underneath the checkbox, not the background color of the checkbox. For instance here I changed that setting from default to magenta:

image description

Also, is there a way to change the color and/or style of the checkmark itself? Default is a thick green check, as shown.

And is there any way to modify the box's border style?

Thanks!

2020-03-02 06:03:09 +0100 코멘트달린 답변 Calc amount of days between dates [solved]

Oh ack. I had the end date cell reference first like a dummy. Thank you, @Schiavinatto.

2020-03-02 01:35:08 +0100 코멘트달린 답변 Calc amount of days between dates [solved]

I must be doing something else wrong, then, because I still get errors. Thanks for the interval information; I just foun

2020-03-02 01:34:15 +0100 받은 배지  논객
2020-03-02 01:33:06 +0100 코멘트달린 답변 Calc amount of days between dates [solved]

I must be doing something else wrong, then, because I still get errors. Thanks for the interval information; I just foun

2020-03-02 01:26:50 +0100 코멘트달린 답변 Calc amount of days between dates [solved]

I must be doing something wrong, then. Thanks for the interval information; I just found it in Help, too.

2020-03-02 00:03:19 +0100 코멘트달린 답변 Calc amount of days between dates [solved]

DATEDIF() gives me Err:511 for the same dates that subtraction works for. Dropbox

2020-03-02 00:03:08 +0100 코멘트달린 답변 Calc amount of days between dates [solved]

DATEDIF() gives me Err:511 for the same dates that subtraction works for. https://www.dropbox.com/s/ahypxo3isk56i47/date

2020-03-02 00:02:30 +0100 받은 배지  개근상
2020-03-01 11:27:18 +0100 받은 배지  선생님 (source)
2020-03-01 03:41:29 +0100 받은 배지  조력자 (source)
2020-03-01 03:09:17 +0100 답변을 편집했습니다 Calc amount of days between dates [solved]

What just worked for me was to format the cells before entering the dates. When I typed in the dates, and then applied t

2020-03-01 01:22:52 +0100 받은 배지  인기있는 질문 (source)
2020-03-01 00:39:17 +0100 코멘트달린 답변 Cell linked to checkbox can do arithmetic but doesn't work in VLOOKUP

Oh, I see. It tries to read minds, which sometimes works and sometimes doesn't. Thank you!

2020-03-01 00:39:05 +0100 코멘트달린 답변 Cell linked to checkbox can do arithmetic but doesn't work in VLOOKUP

Oh, I see. It tries to read minds, which sometimes works and sometimes doesn't. Thank you.

2020-03-01 00:25:56 +0100 으뜸 답변으로 표시됨 Cell linked to checkbox can do arithmetic but doesn't work in VLOOKUP

Note: per m.a.riosv's comment below here's a sample file in Dropbox: link. There's a download button at the top of the right-hand sidebar. (I tried the forum file uploader but it didn't work for me.)


I have checkboxes which are linked to cells named option1, option2, option3. Reference value (on) for all of them is set to 1.

If I tick the checkboxes, I can do arithmetic with the contents of the named cells, e.g. : =option1+10 gives result 11.

But if I use the linked cells in a VLOOKUP formula - =VLOOKUP(option1,lookup,2) - I get #N/A.

If I change the formula to =VLOOKUP(VALUE(option1),lookup,2), it works perfectly.

This gave me fits till I found the solution, but I still don't understand it. If the linked cell stores values as text, why can I do arithmetic with them?

Can anyone explain? Thanks!

2020-03-01 00:12:51 +0100 질문을 편집했습니다 Cell linked to checkbox can do arithmetic but doesn't work in VLOOKUP

Cell linked to checkbox can do arithmetic but doesn't work in VLOOKUP Note: per m.a.riosv's comment below here's a sampl

2020-03-01 00:11:57 +0100 질문을 편집했습니다 Cell linked to checkbox can do arithmetic but doesn't work in VLOOKUP

Cell linked to checkbox can do arithmetic but doesn't work in VLOOKUP I have checkboxes which are linked to cells named

2020-03-01 00:03:36 +0100 질문을 편집했습니다 Cell linked to checkbox can do arithmetic but doesn't work in VLOOKUP

Cell linked to checkbox can do arithmetic but doesn't work in VLOOKUP I have checkboxes which are linked to cells named

2020-03-01 00:00:46 +0100 질문에 댓글을 달았습니다 Cell linked to checkbox can do arithmetic but doesn't work in VLOOKUP

Since the uploader wouldn't work for me, I put it on OneDrive--- --- [edited] except that doesn't work because it wants

2020-03-01 00:00:13 +0100 질문에 댓글을 달았습니다 Cell linked to checkbox can do arithmetic but doesn't work in VLOOKUP

Since the uploader wouldn't work for me, I put it on OneDrive--- --- [edited] except that doesn't work because it wants

2020-02-29 23:59:59 +0100 질문을 편집했습니다 Cell linked to checkbox can do arithmetic but doesn't work in VLOOKUP

Cell linked to checkbox can do arithmetic but doesn't work in VLOOKUP I have checkboxes which are linked to cells named

2020-02-29 23:58:08 +0100 질문에 댓글을 달았습니다 Cell linked to checkbox can do arithmetic but doesn't work in VLOOKUP

Since the uploader wouldn't work for me, I put it on OneDrive

2020-02-29 23:49:31 +0100 질문을 편집했습니다 Cell linked to checkbox can do arithmetic but doesn't work in VLOOKUP

Cell linked to checkbox can do arithmetic but doesn't work in VLOOKUP I have checkboxes which are linked to cells named

2020-02-29 22:46:50 +0100 답변을 편집했습니다 Time average

Just plain average worked for me with no trouble. Maybe start fresh with the formats in case something got messed up? U

2020-02-29 22:14:16 +0100 질문을 편집했습니다 Cell linked to checkbox can do arithmetic but doesn't work in VLOOKUP

Cell linked to checkbox can do arithmetic but doesn't work in VLOOKUP I have checkboxes which are linked to cells named

2020-02-29 22:13:20 +0100 질문을 편집했습니다 Cell linked to checkbox can do arithmetic but doesn't work in VLOOKUP

Cell linked to checkbox can do arithmetic but doesn't work in VLOOKUP I have checkboxes which are linked to cells named

2020-02-29 22:10:19 +0100 질문에 댓글을 달았습니다 Cell linked to checkbox can do arithmetic but doesn't work in VLOOKUP

I just tried. It went through what looked like an upload procedure, but I don't see it in the post.

2020-02-29 22:09:49 +0100 질문을 편집했습니다 Cell linked to checkbox can do arithmetic but doesn't work in VLOOKUP

Cell linked to checkbox can do arithmetic but doesn't work in VLOOKUP I have checkboxes which are linked to cells named

2020-02-29 22:07:02 +0100 질문을 편집했습니다 Cell linked to checkbox can do arithmetic but doesn't work in VLOOKUP

Can do arithmetic but not VLOOKUP I have a checkbox which is linked to, for instance, cell A1. Reference value (on) is s