logical formula help

A

anandsharma

New member
Joined
Aug 25, 2016
Messages
4
Reaction score
0
Points
0
this is anand, in my attached file sheet"StockReport 2014 Opening-Apr", has different category of product which have different slab,from Cloumn P - Column AT, i want to match if p1=n2 then o2 has gram, it should calculate the slab formula using if
 

Attachments

  • help.xlsx
    24.3 KB · Views: 15
  • Capture.PNG
    Capture.PNG
    88.7 KB · Views: 22
Please give an example of results you expect. I don't understand the request.
 
You request is a little confusing. So I'm not sure if this is what you were trying to do?

=IF(I2="GOLD PLAIN",F2,H2)&IF($P$1=N2," gram","")
 
attachment.php
Excel Surgeon said:
You request is a little confusing. So I'm not sure if this is what you were trying to do?

=IF(I2="GOLD PLAIN",F2,H2)&IF($P$1=N2," gram","")
Click to expand...


SIR THANKS FOR REPLY.

I AM TRYING TO GET OUTOUT IN P2_CELL; i.e., IF P1(GOLD PLAIN BANGLES SET 2)= N2(GOLD PLAIN BANGLES SET 2)MATCH THEN INDEX O2(CRITERIA) THAT IF(O2>=5000,"0-5GM",IF(O2>=20000,"6-20GM,"21+GM")..

I ADDED SCREEN SHOT ALSO & FILE TOO
 

Attachments

  • Capture.PNG
    Capture.PNG
    88.7 KB · Views: 33
  • Book1.xlsx
    274.9 KB · Views: 14
excelLogical help

SIR THANKS FOR REPLY.

I AM TRYING TO GET OUTOUT IN P2_CELL; i.e., IF P1(GOLD PLAIN BANGLES SET 2)= N2(GOLD PLAIN BANGLES SET 2)MATCH THEN INDEX O2(CRITERIA) THAT IF(O2>=5000,"0-5GM",IF(O2>=20000,"6-20GM,"21+GM")..

I ADDED SCREEN SHOT ALSO & FILE TOO
 

Attachments

  • Book1.xlsx
    274.9 KB · Views: 15
  • Capture.PNG
    Capture.PNG
    88.7 KB · Views: 14
I am still a little bit confused. The formula you highlighted on the screenshot is different than the formula you just mentioned in your post.

Is this what you are going for?

If P1=N2 then we use the formula IF(O2 > =5000,"0-5GM",IF(O2 > =20000,"6-20GM,"21+GM")

if they are not equal we use the formula you highlighted in the screenshot?

Let me know if I'm getting it correct?
 
You must log in or register to reply here.
Back
Top