Ask Your Question

Havaneiss Dei's profile - activity

2019-01-13 23:46:10 +0200 received badge  Notable Question
2019-01-09 13:43:07 +0200 received badge  Famous Question (source)
2019-01-09 13:39:45 +0200 received badge  Popular Question
2019-01-08 17:16:19 +0200 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 +0200 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 +0200 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 +0200 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 +0200 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 +0200 received badge  Notable Question (source)
2018-12-16 22:21:43 +0200 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 +0200 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 +0200 received badge  Supporter (source)
2018-12-16 22:11:44 +0200 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 +0200 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 +0200 received badge  Popular Question (source)
2018-12-16 17:29:04 +0200 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 +0200 received badge  Famous Question (source)
2017-12-06 08:09:46 +0200 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 +0200 received badge  Notable Question (source)
2017-06-12 14:17:24 +0200 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 +0200 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 +0200 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 +0200 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 +0200 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 +0200 received badge  Popular Question (source)
2017-06-12 14:03:02 +0200 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 +0200 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 +0200 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 +0200 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 +0200 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 +0200 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 +0200 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 +0200 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 +0200 received badge  Notable Question (source)
2016-09-22 14:49:03 +0200 received badge  Editor (source)
2016-09-22 14:18:09 +0200 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 +0200 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 +0200 received badge  Popular Question (source)
2016-09-21 15:03:51 +0200 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 +0200 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