IF FUNCTION ISN'T WORKING NO MATTER HOW SIMPLE THE COMMAND IS
Hi, I was trying to use the IF function and it wasn't working so i tried to make it as simple as possible to see what the problem was. Still, it gave me an error even though I just copied and pasted the formula from windows support page so I don't really know what to do.
How to keep hyperlink in cells being accessed with IF function across workbooks?
Hello community, I have a workbook that contains a table of insurance industry regulatory filings (called "master filings"). One of the columns provides a link to a PDF of the regulatory filing itself, for people that want to look at the original document. Can anyone help figure out how to carry those links over to a second workbook? Here's a breakdown of the situation: I am building a secondary workbooks that only have entries for regulatory filings that meet certain criteria. For example, I want to build a workbook that only shows the life insurance filings captured in "master filings" and not other types of insurance filings. I successfully used an IF statement to get this data into the second worksheet (basically: if type=life_insurance, insert row,""). The IF statement works for taking the actual text of all desired cells matching the life insurance reg filings into the new worksheet. However, one cell that contains a link to the online PDF of the actual regulatory filing does not send along the link. So in the master workbook, I have a working hyperlink in the word "link", but when it gets carried over to the new workbook, the hyperlink isn't there; only the text for "link" comes along. Does anyone know how to get Excel to bring the hyperlink itself over to the new workbook? Many thanks for any advice! I have attached screenshots showing an example.
Help with an IF AND formula
I am having trouble wording a formula that will bring up "Incomplete" if Programming Course and Network Course have even just one "N" and "Complete" if they both have "Y". I included a screenshot to show how close I got but it's still not the correct one. I would greatly appreciate any assistance.2 lists, 1 if
Hi everyone. I'm trying to create such an IF command, that if a certain cell is empty, nothing happens, if it has lets say "1" a certain list prepaired earlier appears, if "2" a different list appears. When attempting to perform the command =IF(A1="";"";IF(A1=1;list1;list2)). I don't have to consider other possibilities other than these 3. When I imput this formula, if A1 is empty, no list appears, which is good, but if I imput an other value (correct for the formula or not) it immediatly creates "list2" Additional question, is it possible, to create a counter of amount of appearences in the program. Lets say the above formula, or corrected by you, works. I'll have a few people listed and because depending on the date and localization that the person appears/will appear, can I set a counter, that will not print, but count the amount of dates "John" or "Sally" appeare in the calendar, even thos, the information is being sent from a list? Thanks
