If Then statement help needed
 

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

=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)))

--
Regards,
Tom Ogilvy

"jmcclain" wrote in message
...
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

Might also be an admissible route...

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

jmcclain wrote:
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