# Excel Nested If

Occasional Visitor

# Excel Nested If

Use the product code breakdown provided to create appropriate nested functions to complete the following: If the product is White and 240 V insert the product Price, otherwise the cell should be

blank. If anyone can help me out with a formula

 1st character 2nd character 5th character 6th character P Premium R Refrigerator S Stainless steel 1 120 V S Standard S Stove W White 2 240 V D Dishwasher B Black M Microwave W Wall oven 1st character 2nd character 5th character 6th character P Premium R Refrigerator S Stainless steel 1 120 V S Standard S Stove W White 2 240 V D Dishwasher B Black M Microwave W Wall oven
2 Replies

# Re: Excel Nested If

That's like

`` =IF( (product="White")*(haveNoIdeaWhat="240 V"), productPrice, "")``

# Re: Excel Nested If

Something like this: =IFERROR(IF(AND(FIND("W",[p code],5),FIND("1",[p code],5)),[price],""),"")
where [p code] is the reference to the product code cell(s) and [price] is a reference to the price cell(s)
but it is unclear if the "W" for White is the 5th character or after the 6th character. The 5 above assumes it is the 5th but would need to be 6 or 7 if the "W" for Wall oven is the 5th character as indicated in the image.
Also if the 5th character is color and the 6th character is voltage then you could simplify it to:
=IFERROR(IF(FIND("W1",[p code],5),[price],""),"")