montanaaggie
Board Regular
 Joined
 Nov 11, 2005
 Messages
 122
 Office Version

 365
 Platform

 Windows
I have a range of data in cells A1: C4
0% 15% CO2
15% 40% WATER
40% 60% CO2
60% 100% WATER
I then have a data point in D4 that is calculated based on a equation. I would like to have an equation in E4, that would look at the number in D4 and bring back its corresponding match in C4. Example 16% it would display Water, at 45% it would display CO2. I'm not exactly sure how to structure my IF statement to have this work.
Thanks,
Dave
0% 15% CO2
15% 40% WATER
40% 60% CO2
60% 100% WATER
I then have a data point in D4 that is calculated based on a equation. I would like to have an equation in E4, that would look at the number in D4 and bring back its corresponding match in C4. Example 16% it would display Water, at 45% it would display CO2. I'm not exactly sure how to structure my IF statement to have this work.
Thanks,
Dave