Andrews Felix
New Member
- Joined
- Sep 17, 2022
- Messages
- 15
- Office Version
- 2019
- Platform
- Windows
Hi,
If i have a data for (A1:100, C1:100) and here column C is empty and we have to calculate values based on other two columns. For example if A1 > 100 and B1 is "dog" i need C1 to be "good". Here column B will have three different types of animal and column A will have number upto 300. ">100" "100 to 200" and "200 to 300". Column C should get the values, if column A and B meets a criteria.
If i have a data for (A1:100, C1:100) and here column C is empty and we have to calculate values based on other two columns. For example if A1 > 100 and B1 is "dog" i need C1 to be "good". Here column B will have three different types of animal and column A will have number upto 300. ">100" "100 to 200" and "200 to 300". Column C should get the values, if column A and B meets a criteria.