19 нояб. 2013 г. · I'm working on a spreadsheet in which I would like the cell to display "T" if referenced cell is equal to 11, 12, 14, 15, 18, 19, 60 or 61 / "B" if referenced ...

10 сент. 2013 г. · I have four separate cells that should all contain the same value. I want to build a check formula that compares these, but I'd like to do it in one cell and ...

7 янв. 2021 г. · Using IF, AND & OR, I have managed to obtain TRUE & FALSE returns for 3 Cells where each has 2 possible values.

14 нояб. 2023 г. · I am still learning VBA and previously had some code that compared a cells value against a variable that I had multiple different values stored in.

24 апр. 2021 г. · Since multiple values are in a single cell, the cell is text. I know the Value function, multiplying by 1 or adding a 0 can fix the number saved as text to an ...

9 нояб. 2020 г. · I have a spreadsheet that returns multiple results based on an order number in columns E to G. I would like to combine those results into a single cell with "/ ...

6 мар. 2003 г. · If the value is equal to any of the values in the range of cells, then it returns true. Excel Facts.

8 апр. 2024 г. · Hi, I wanted to craft a formulae that would allow me to do the following: If A1 = "black", then the cell would equal 20, If A1 = "green", ...

2 авг. 2017 г. · I would like to set up a logic that says something like: Check to see if cells A1:W1 are equal to these strings in succession.

27 мая 2022 г. · Hello, Need help on trying to use an if statement that will compare one cell to the other. The issue is one cell has multiple answers separated ...