Need Assistance on IF/NESTED IF function

[Dhinakaran]

Hi All,

Request for assistance on the IF/NESTED if function on the below table. Regret as I'm not sure if NESTEDIF would be a valid formula on below case.
- In the below table, I have certain products with header Grade (Column A) and its selling price and purchase price in corresponding columns (B&C).
- Under the status column, Whenever any Grade is sold for a higher price than its purchase price the status column should be highlighted with High and Low text.
- Did try the IF function while we can only apply it in the cell which has values only and not text.

For instance, lets take A+ grade who purchase price is 700 while it is sold for 500 and would want the status column to be reflected as High.

Book5
	A	B	C	D
1	Grade	Purchase Price	Sell Price	Status
2	A+	700	500
3	A	800	400
4	B+	600	300
5	B	400	200
6	C	200	100
7	Others	150	50
Sheet1

 

[Fluff]

Maybe

=IF(B2>C2,"High","Low")

 

[Dhinakaran]

Maybe

=IF(B2>C2,"High","Low")

Thank Fluff, But this would be based on values in B2&C2. I would expect B2&C2 to be compared on Grade and then provide the result.

 

[Fluff]

I would expect B2&C2 to be compared on Grade and then provide the result.

In what way? you only have one of each grade.

 

[Dhinakaran]

In what way? you only have one of each grade.

Just to clarify, I would needs the result as High or Low in status column basis comparing the grade in column A.
For instance, I would compare Grade A against its Purchase price and Selling price and update the status column. Basically an assumed formula as below.
- IF(A+>=700,"High","Low").

Con: While with the regular IF formula it can populate the result only by comparing the values as shared by you earlier i.e, =IF(B2>C2,"High","Low").

TIA.

 

[Fluff]

Do you have a list of what the grades mean in terms of their price?

 

[Dhinakaran]

Do you have a list of what the grades mean in terms of their price?

You may consider the purchase price against the grade. So, Lets say if a sale happens for Grade A+ whose purchase price is 700 while the selling price is 500 or higher. In the status column, I would want to consider the sold grade's purchase price and sold price and populate the result as Profit or Loss.

 

[Fluff]

I'm sorry but you are making no sense to me.
Each of your Grades only occurs once in your data & they would all be High as the purchase price is greater than the sale price.

 

[Dhinakaran]

I'm sorry but you are making no sense to me.
Each of your Grades only occurs once in your data & they would all be High as the purchase price is greater than the sale price.

So, would there be any solution in case if the grades are repeated as below.
A+
A
B+
B
C
Others
B+
A

 

[Fluff]

If I understood what you were trying to do, then very probably.
You need to explain exactly what you are trying to do, along with some examples.