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