Posts by Pecoflyer

Shorter version

=OR(AL2={5,10,25,50,100})

Also be aware that formatting is the way XL shows contents to the outside world. The underlying value is a number. e.g. 0.6666666 is the same as 16:00:00 or 04:00:00 PM, etc.. Formatting will NOT change the underlying value which XL will use for calculations

Perhaps

=E5*(E3*A7+5))

What is supposed to happen if E5<>1 or 2, or E3>20 or E3<1?

I haven't followed the entire discussion, just wanted to add that in O365 ALL formulas are array formulas by default AFAIK. So, entering with CSE is not necessary any more. ( to remove the feature the formula should be preceded by a @)

Quote from Carim

Would be Great if we, all, could benefit from the OP's feedback ... !!!

After 7000 + posts you still wonder ?

I've thousands of posts on another forum, and it still frustrates me every day

1. Your strings in col B in the TELUS sheet are text while in the other sheet they are numbers so they cannot match

2.=VLOOKUP($B2,TELUS_SEPT_2022!$B$2:$C$1469,3,0) is impossible as you are looking in the 3rd column of a two column range ( the lookup column refers to the range in your formula, not the position in the sheet

Try

=VLOOKUP($B2&"",TELUS_SEPT_2022!$B$2:$C$1469,2,0)

instead and pull down

As text is left aligned in cells and number are right aligned, NEVER apply manual alignment of columns before your formulas are working

Seeing your workbook ( not a picture) would help..

Your sheet seems to be protected ? Still using XL 2007? Please add some expected results. Thx

Cross posted at https://chandoo.org/forum/thre…p-to-pdf-and-email.50423/

and at

I want generate All Employee payslip in PDF on 1 Button=VBA codes gives error PLS HELP

Why not simply use MSWord's Mail Merge?

Lots of tips and tricks at https://www.msofficeforums.com…ailmerge-tips-tricks.html and https://yamm.com/blog/mail-merge-excel/

ruppk825 Please add your XL version to your profile, as answers are tailored to the version you are using. Thanks

Quote from PatrickOfLondon

I've also searched the Registry for it and it doesn't seem to be there either.

Have you observed in the provided clip that when the Key is not present you can add the DWORD yourself to the registry?

Cross posted on at least 4 other forums

Just a wild guess. Have you tried enabling/disabling hardware acceleration ?

For pre-O365 versions see https://www.top-password.com/b…-acceleration-for-office/

For O365have a look at

Quote from RAJESH SHAH

I have faced this date problem many a times in my past applications .Hopefully I will come up with something to solve this problem too

To make your XL experience easy, DO NOT apply manual alignment to ranges you will use in formulas. Why ? Because text is always left aligned by default in the cells. So, if you see a left-aligned date, you immediately know you have to (probably) work on it

Quote from Carim

for Excel this is THE beginning of Time !!!

Quote from RAJESH SHAH

That I can do by selecting the A column from cell A2 to end in the raw data sheet, right click and convert it into dd-mm-yyyy

You might want to read https://www.excelcampus.com/fu…/how-dates-work-in-excel/ to understand how it works

Why did you start a new thread? It makes things confusing for the forum members

You can enter a range in the Holidays argument containing formulas that calculate variable holidays

I found one for Easter at https://www.contextures.com/exceleastercalculation.html

As for Labor day, it depends on the country I suppose. So, search the Net for other variable dates you need, there is probably an answer out there

Quote from rory

I know, but you asked for a formula, so...

Same here