if formula problem

I am trying to put in a formula that will remain blank if the target cell is blank, show 1 if the target cell is "Yes" and show 0 if the target cell is "No". Here is the current formula: =IF([@[Primary covered]]=" "," ",IF([@[Primary covered]]="Yes","1","0")) [@[Primary covered]] is E2 in the...

Hi. I have zero knowledge of excel VBA. I am working on a project. From a seperate program i am able to export reports into an excel spreadsheet. I want to copy and paste the spreadsheet into another excel workbook that has a Macro waiting to be used. The report results are always the same...

Good day all. I am using excel 2016 I am trying to do a seemingly easy IF formula but every way I write it I get an error What I am trying to do is as fallows: IF any cell in Column J = 1 then I would like cell F1 to subtract the value in cell H1 Any help would be great. Cheers

Hi, I would like to compare column A and column B and calculate how much % B is of A. So I added column C with formula "=B/A" However some of the values in A and B are 0, which result in a statement "Not a number" in column C. Unfortunately pivot tables can't handle this as a value. So I...

Hi All, I know what I am wanting to do but I can't find the right written expression to generate the results. What I wanting is column J to do the following: If F2>1 then D2 – F2 or if F2 is blank D2+E2*H2 Sample <!--StartFragment--> <colgroup><col width="65" span="10"...

Ok what am I doing wrong here. I have a worksheet that lists employee numbers and their cost centers. Some of the cost centers are blanks in the worksheet, but all the employee numbers are always filled. Basically, I'm trying to fill the blanks in column C (Cost Center), based on the data in...

Please help - I am desperate... can Excel do a double if formula by looking at cells and not fixed type info. EG: I have a % achieved and $ bonus to pay: however the % achieved & the $ bonus to pay information in the cell will change each month So... I want the formula to say =IF (look...

Hey guys I am trying to perform an if formula on a cell which will be either blank or have a value depending on different inputs in a different worksheet. =IF(AP3>AP$51,"SIGNS OF FATIGUE","OK") This is the formula I have tried however i get a #DIV/0! when i perform it. Is there a way to ignore...