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 |

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

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

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 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 If I tick the checkboxes, I can do arithmetic with the contents of the named cells, e.g. : But if I use the linked cells in a VLOOKUP formula - If I change the formula to 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 |

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 |

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

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 |

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 |

Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.