First time here? Check out the FAQ!

2019-01-14 21:02:46 +0100 | commented answer | Is there a way to delete all the empty cells preceding data, basically left-justifying the cells into columns? Wow. That is way over my head. I ended up deleting the cells manually. An issue in the same spreadsheet involved oodl |

2019-01-14 20:54:36 +0100 | commented answer | Is there a way to delete all the empty cells preceding data, basically left-justifying the cells into columns? Wow. That is way over my head. I ended up using the shift key and manually clicking on each tiny jpeg to form groups, |

2019-01-13 23:46:10 +0100 | received badge | ● Notable Question (source) |

2019-01-09 13:43:07 +0100 | received badge | ● Famous Question (source) |

2019-01-09 13:39:45 +0100 | received badge | ● Popular Question (source) |

2019-01-08 17:30:48 +0100 | asked a question | Is there a way to delete all the empty cells preceding data, basically left-justifying the cells into columns? Is there a way to delete all the empty cells preceding data, basically left-justifying the cells into columns? I've begu |

2019-01-08 17:16:19 +0100 | edited question | [SOLVED] Day() doesn't return the correct value. {Oops!
User Error} [SOLVED] Day() doesn't return the correct value. {USER ERROR} I'm currently working in Calc with dates in the 1300s and |

2019-01-08 17:15:15 +0100 | edited question | [SOLVED] Day() doesn't return the correct value. {Oops!
User Error} Day() doesn't return the correct value. I'm currently working in Calc with dates in the 1300s and 1400s. The "Day()" fu |

2019-01-08 17:13:51 +0100 | commented answer | [SOLVED] Day() doesn't return the correct value. {Oops!
User Error} Thanks for the bug submission; I found the recommended way of solving the problem to be better and got distracted with m |

2019-01-08 17:13:42 +0100 | commented question | [SOLVED] Day() doesn't return the correct value. {Oops!
User Error} Thanks for the bug submission; I found the recommended way of solving the problem to be better and got distracted with m |

2019-01-08 17:13:01 +0100 | commented question | [SOLVED] Day() doesn't return the correct value. {Oops!
User Error} Thanks for the bug submission; I found the recommended way of solving the problem to be better and got distracted with m |

2018-12-17 13:22:19 +0100 | received badge | ● Notable Question (source) |

2018-12-16 22:21:43 +0100 | commented question | [SOLVED] Day() doesn't return the correct value. {Oops!
User Error} Hi, Lupp! Oops! I didn't intend to indicate that I thought of differences in dates, as dates; however, I can now see t |

2018-12-16 22:14:53 +0100 | commented answer | [SOLVED] Day() doesn't return the correct value. {Oops!
User Error} Greetings, erAck! The recommended replacement seems to work well, but incorporating it into the sort of string that I'm |

2018-12-16 22:13:47 +0100 | received badge | ● Supporter (source) |

2018-12-16 22:11:44 +0100 | commented answer | [SOLVED] Day() doesn't return the correct value. {Oops!
User Error} The recommended replacement seems to work well, but incorporating it into the sort of string that I'm using will take mo |

2018-12-16 21:56:35 +0100 | commented question | [SOLVED] Day() doesn't return the correct value. {Oops!
User Error} Hi, Lupp! I tried DATEDIF() before I read your reply; you may want now to question your self-image (because we're think |

2018-12-16 18:38:55 +0100 | received badge | ● Popular Question (source) |

2018-12-16 17:29:04 +0100 | asked a question | [SOLVED] Day() doesn't return the correct value. {Oops!
User Error} Day() doesn't return the correct value. I'm currently working in Calc with dates in the 1300s and 1400s. The "Day()" fu |

2017-12-06 11:23:10 +0100 | received badge | ● Famous Question (source) |

2017-12-06 08:09:46 +0100 | marked best answer | [Solved] Need Vlookup to return smallest value greater than or equal to search criterion Example: A1 = 26 A2 = 80 A3 = 95 B1 = 950 B2 = 1500 B3 = 1650 C1 = 99 C2 = 3 =VLOOKUP (C1/C2,A1:B3,2,1) returns 950 I need it to return 1500. However, if C1=52 and C2=2, I need it to return 950. I am not stuck on using VLOOKUP: I just need a formula that will work! |

2017-06-14 12:28:25 +0100 | received badge | ● Notable Question (source) |

2017-06-12 14:17:24 +0100 | edited answer | [Solved] Need Vlookup to return smallest value greater than or equal to search criterion Hi! =IF (ISNA (VLOOKUP (C1/C2,A1:B3,2,0)=1,INDEX(B1:B3,MATCH(C1/C2, A1:A3)+1),VLOOKUP (C1/C2,A1:B3,2,0)) seems to work |

2017-06-12 14:16:42 +0100 | edited answer | [Solved] Need Vlookup to return smallest value greater than or equal to search criterion Hi! =IF (ISNA (VLOOKUP (C1/C2,A1:B3,2,0)=1,INDEX(B1:B3,MATCH(C1/C2, A1:A3)+1),VLOOKUP (C1/C2,A1:B3,2,0)) seems to work |

2017-06-12 14:15:59 +0100 | answered a question | [Solved] Need Vlookup to return smallest value greater than or equal to search criterion Hi! =IF (ISNA (VLOOKUP (C1/C2,A1:B3,2,0)=1,INDEX(B1:B3,MATCH(C1/C2, A1:A3)+1),VLOOKUP (C1/C2,A1:B3,2,0)) seems to work |

2017-06-12 14:13:46 +0100 | edited question | [Solved] Need Vlookup to return smallest value greater than or equal to search criterion Need Vlookup to return smallest value greater than or equal to search criterion Example: A1 = 26 A2 = 80 A3 = 95 B1 |

2017-06-12 14:05:41 +0100 | edited question | [Solved] Need Vlookup to return smallest value greater than or equal to search criterion Need Vlookup to return smallest value greater than or equal to search criterion Example: A1 = 26 A2 = 80 A3 = 95 B1 |

2017-06-12 14:04:36 +0100 | received badge | ● Popular Question (source) |

2017-06-12 14:03:02 +0100 | edited question | [Solved] Need Vlookup to return smallest value greater than or equal to search criterion Need Vlookup to return smallest value greater than search criterion Example: A1 = 26 A2 = 80 A3 = 95 B1 = 950 B2 = |

2017-06-12 14:02:09 +0100 | commented answer | [Solved] Need Vlookup to return smallest value greater than or equal to search criterion Hi! That seems to be a step in the correct direction, but it chooses the higher value even when C1/C2 = A1. I ended up |

2017-06-12 14:01:29 +0100 | commented answer | [Solved] Need Vlookup to return smallest value greater than or equal to search criterion Hi! That seems to be a step in the correct direction, but it chooses the higher value even when C1/C2 = A1. I ended up |

2017-06-12 08:35:38 +0100 | edited question | [Solved] Need Vlookup to return smallest value greater than or equal to search criterion Need Vlookup to return smallest value greater than search criterion Example: A1 = 26 A2 = 80 A3 = 95 B1 = 950 B2 = |

2017-06-12 08:32:51 +0100 | edited question | [Solved] Need Vlookup to return smallest value greater than or equal to search criterion Need Vlookup to return smallest value greater than search criterion Example: A1 = 26 A2 = 80 A3 = 95 B1 = 950 B2 = |

2017-06-12 08:31:25 +0100 | edited question | [Solved] Need Vlookup to return smallest value greater than or equal to search criterion Need Vlookup to return smallest value greater than search criterion Ex: A1 = 26; A2 = 80; A3 = 95; B1 = 950; B2 = 15 |

2017-06-12 03:56:17 +0100 | asked a question | [Solved] Need Vlookup to return smallest value greater than or equal to search criterion Need Vlookup to return smallest value greater than search criterion Ex: A1 = 26 A2 = 80 A3 = 95 B1 = 950 B2 = 1500 B3 = |

2017-05-14 16:14:30 +0100 | answered a question | Recovery failed, previously saved file disappered In RE the badvice that anyone simply give up and buy MS Office: I owned legit MS software and every MS "operating system |

2016-09-22 16:53:30 +0100 | received badge | ● Notable Question (source) |

2016-09-22 14:49:03 +0100 | received badge | ● Editor (source) |

2016-09-22 14:18:09 +0100 | answered a question | Calc isn't accepting new nested "IF" functions; previously worked fine. How to fix? SOLVED. Refer to comment by Lupp. Thanks to the whole community of helpful folks; special thanks to Lupp for the helpful answer. |

2016-09-22 14:16:33 +0100 | commented question | Calc isn't accepting new nested "IF" functions; previously worked fine. How to fix? Can't believe I missed that! I did the setup in Writer, then C&P. DOH! |

2016-09-22 14:11:40 +0100 | received badge | ● Popular Question (source) |

2016-09-21 15:03:51 +0100 | commented question | Calc isn't accepting new nested "IF" functions; previously worked fine. How to fix? =IF(AND(B$3<>“”,$A4>0,$A4<=B$3),“POS”,(IF(AND($A4=0,B$3<>“”,B$3>=0),“Q1Z”,(IF(AND($A4<0,B$3<>“”,B$3>=0),“-N-”,(IF(AND($A4<0,B$3<>“”,B$3<0),“NEG”,“”))))))) |

2016-09-21 12:31:10 +0100 | asked a question | Calc isn't accepting new nested "IF" functions; previously worked fine. How to fix? LibreOffice Version: 4.2.8.2, Build ID: 420m0(Build:2) Computer is laptop (iBUYPOWER CZ-17; motherboard is proprietary, but similar to MSI-1762) with the following specs: CPU: Intel Core i7-3630QM @ 2.40 GHz RAM: (4x) GSKILL DDR3-1333 MHz 4GB SO-DIMM (16.0 GB installed; 15.9 GB usable) SSD: Mushkin Enhanced Reactor 1TB OS: Linux Mint Rebecca Cinnamon |

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