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

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 …

We use cookies to personalise content and ads, to provide social media features and to analyse our traffic. We also share information about your use of our site with our social media, advertising and analytics partners. How Google uses data when you use our partners' sites or apps

The cookie settings on this website are set to "allow cookies" to give you the best browsing experience possible. If you continue to use this website without changing your cookie settings or you click "Accept" below then you are consenting to this.