If statement assistance needed

[dfund]

I'm trying to set up a quote spreadsheet for sales people to enter data and it show a price quote for a customer. I have a drop down menu (name of service) with 4 items (cell B4) and another drop down menu with 8 selectable speeds (G4). These relate to the pricing which is on a worksheet called Pricing. I can make part of this work with this formula - =IF(((B4="Wireless")+(G4="3 Mbps")),Pricing!C3). However even this does not work well. If I change the selection in G4 it does not change the pricing. Suggestions would be appreciated.

 

[cstimart]

I'm trying to set up a quote spreadsheet for sales people to enter data and it show a price quote for a customer. I have a drop down menu (name of service) with 4 items (cell B4) and another drop down menu with 8 selectable speeds (G4). These relate to the pricing which is on a worksheet called Pricing. I can make part of this work with this formula - =IF(((B4="Wireless")+(G4="3 Mbps")),Pricing!C3). However even this does not work well. If I change the selection in G4 it does not change the pricing. Suggestions would be appreciated.

Try this...

=IF(AND(B4="Wireless",G4="3 Mbps"),Pricing!C3,0)

 

[dfund]

PERFECT! Thank you.