If Then statement help needed

[jmcclain]

I have the following date in tab a of a spreadsheet

B6 = 10.80
c6 = 10.35
d6 = 9.99

In a different tab, i will be inputting a qty to order, either 500, 750, or
1,000. I need an if then type function to insert the respective price from
above based on the qty that is input.

I have gotten the following to work for 2 conditions:

=IF(J25=500,'Custom Instock price grid'!B6,IF(J25=750,'Custom Instock price
grid'!C6))

However, i haven't been able to get the last condition whereby if the
previous 2 are false, then use the value in d6 to work.

Can someone help with the syntax?

Thanks

Jon

 

[Tom Ogilvy]

=if(and(J25<>500,J25<>750,J25<>1000),"",IF(J25=500,'Custom Instock price
grid'!B6,IF(J25=750,'Custom Instock price grid'!C6,'Custom Instock price
grid'!D6)))

 

[Aladin Akyurek]

Might also be an admissible route...

=INDEX('Custom Instock price grid'!$B$6:$D$6,MATCH(J25,{500;750;100},0))