## Help with IF(AND(OR

Hi, I have the following formula: …

Hi, I have the following formula: …

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, …

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 …

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 …

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 …

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, …

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. …

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

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 …