## If/AND with multiple cells

How would I find an IF statement if I also need an AND statement? Ex. “If any of the numbers in cells B1, C1, D1 are equal to 5, multiply them together, …

## Matrix and kilometers

Dear reader, The Matrix below shows the distances between different cities in Poland. I have a dataset with courier services where the recipient city and …

## Check multiple cells to show the one with a result

Hello, I need help with a formula.   There are 4 cells, only one will show a result at a time, I need a formula that will check the 4 cells and return as …

## I think I Need an ANDIF / Match formula, but not sure

Hi All, thanks so much for taking the time to read this, hopefully I am clear in what I am asking and doing everything correct according to the forum …

## if and and time

I’ll outline the situation: I’m assigning different prices for energy being consumed within different time periods within a day. 23:00-7:59 is x, …

## Complicated nested IF AND OR statement….

Ok here goes…. So I am trying to evaluate two sets of values in two cells let’s just say, for the sake of argument, cell A1 and cell B1.   …

## Excel If and AND Functions

Hello,   Please could you help. i need a formula for IF Column B had data in and Column J is Empty then do this …

## excel

BANK TRANSFER POS 1.5% CASH FORM OF PAYMENT 0.00 0.00 0.00 TEXT IF THERE IS A VALUE OF MORE THAN 0.01 ONLY IN BANK TRANSFER BUT ZERO IN POS OR CASH THAN FORM …