excel if function

Hi all, I have built a report with some financial transactions checking. The scenario is, (col A) company "1" sends money to (col B) company "2" so the common value in column C will be "12" (cell A & cell B). But if the company "2" sends money to "1" then in column C we will have "21". What...

=IF(F:F="29.04.2021",COUNTIF(E3:E1000,"ok")) =IF(F:F="30.04.2021",COUNTIF(D3:D1000,"Afternoon")) I am using this formula, if column F:F there is text "29.04.2021" then against that row if there are any "ok" in column E:E1000 then it will count the number of "ok" in the designated cell, but...

Hi, I am trying to execute an if statement across a range of cells: for instance I have 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000 For the top row I have the formula =if(AND(B1="",A1=1,000),"Yes","No"). Which...

Hi can I please ask for help is it possible to use IF to Time? If its between 08:00 - 15:59 CST time it will be AMER If its between 16:00 - 23:59 CST Time APAC If its between 00:00 - 07:59 CST Time EMEA I tried...

Hello all, I know the title isn't the best, but I can't think of how to word it. Basically, the software I'm using is not supposed to pay the employees more than x amount (in the example I will provide, x amount = 1,000). The program exports an excel file with the name in column a, the week...

So I have a spreadsheet with date running down columns. At the end of the row I have a formula in 7 columns. In each column it has the formula = IF(A2=AA1,B2,0) + IF(D2=AA1,E2,0) + and so on. The function is that at the end of each row there is a sum total for each variable represented in the 7...

HI SANDY HERE, HI FRIENDS I NEED AN URGENT HELP AS I AM BEGINNER TO EXCEL AND LEARNING THINGS AS I CAME ACROSS, I HAVE A REQUIREMENT AND I HAVE MENTIONED A SAMPLE BELOW ANY HELP WOULD BE GREATLY APPRECIATED . WHOLE DATA VALUES ARE IN TEXT FORMAT. THANKS. Have 6 columns WITH DATA SAMPLE ...

Hello I'm having trouble with a bit of a tricky IF function on microsoft excel. I'll attempt to put this into words.. Basically, I have Column A set to multiples of 1.6. So, starting at 0, 1.6, 3.2, 4.8, etc. all the way to several hundred (years) In Column B I have multiples of 0.308. So...

Dear all, I wold like to ask some question that make me difficult to use excel " IF" I would like to write "IF" function in my Excel data. The following is that I would like to write. If A1 is less...