Wikipedia:Reference desk/Archives/Computing/2021 March 10

Welcome to the Wikipedia Computing Reference Desk Archives
The page you are currently viewing is a transcluded archive page. While you can leave answers for any questions shown below, please ask new questions on one of the current reference desk pages.

March 10

Excel

I am not sure how to ask this question but this is related to Microsoft Excel. I have data in two columns ( column 1 and column 2). One column has heading as Gender and has values in form of male and female, for example I have total 70 entries and out of which 40 are female and 30 are male. Another column has values in numbers, for example 5, 6,3, 4 etc. What I want to do is that I want to subtract values given in the second column but the value subtracted depends if the cell belongs to a male or a female. If it belongs to female, I want to subtract 2 but if belongs to male I want to subtract 3 from the second column. How this operation can be performed?Can someone explain please? Thanks a lot. — Preceding unsigned comment added by 116.71.6.118 (talk) 16:26, 10 March 2021 (UTC)

Note that Excel labels columns with letters, not numbers.

You can use a formula to do that. If your "column 1" is A and your "column 2" is B, and supposing that it is in row 1, enter (in the cell that the result should go in) =A1-IF(B1="Male", 3, 2). (If the location is different, replace the A, B, or 1s as appropriate; you can alternatively click on the data cells to fill in the references.)

For information about how this works: [1], [2]

After doing the first one, you can select the cell, then click and hold on the little square in its bottom-right, and drag down, to duplicate the formula to the rest of the cells below with the necessary adjustments.

--116.86.4.41 (talk) 18:24, 10 March 2021 (UTC)

JSON error downloading Word attachments from Yahoo mail

Hey all. I am experiencing an error I've never had before, from something I do all the time. My Google searches to identify the issue failed. I am getting the following error when attempting to download either of two Word documents from my Yahoo email account, emailed to me from my work colleague (or to download them together as a zip file):

With JSON invoked (in blue), next to "Raw Data" and "Headers", I get:

error	
code  "EC-4008"
requestId  "<removed>"

(I'm not really sure what the requestID is, but I have removed it above over privacy concerns.) As some context, I had my colleague switch from one email provider to a Gmail account and re-send the same files, and I am getting the same error message. I receive Word documents emailed from this colleague all the time, who attaches them from the same computer as the one used for this email to me. I am on an iMac. Any ideas? --Fuhghettaboutit (talk) 18:41, 10 March 2021 (UTC)

Try getting your colleague to either make a very minor modification to the files, or to ZIP them themselves. It's possible that Yahoo only keeps one copy of each file it detects as unique (via some hash and filesize) and somehow their internal copy has problems so resending it doesn't help. If you can't do that for some reason, you could try using IMAP or maybe the mobile app to retrieve the attachment. It's possible the problem is only on their web client. If even that fails, it's possible that Yahoo is detecting the files as dangerous but for some reason isn't displaying a proper error message, or otherwise trying to process them and failing. Unfortunately in that case your options are limited. You could try sending it as a encrypted archive, but many emails services block this on either the sending or receiving end or both. You need to encrypt the file in some way that is has no recognisable header, and also ensure it has no extension that will be considered a problem. Alternatively you'll need some other way to send it. Nil Einne (talk) 22:54, 11 March 2021 (UTC)