Hi,
Could someone let me know if my thinking on this function is correct?
=IF(AND(V10<=16000, V10>=10500),1000,V10/10)
If my understanding is correct then what it's saying is that if the value in cell V10 is between 10500 and 16000 then the value in this field should be 1000 but if it's not between 10500 and 16000 then divide the number by 10 and show that number.
I'm trying to convert it into a query in Access and if my assumption is correct then I should be on to a winner...cheers
Could someone let me know if my thinking on this function is correct?
=IF(AND(V10<=16000, V10>=10500),1000,V10/10)
If my understanding is correct then what it's saying is that if the value in cell V10 is between 10500 and 16000 then the value in this field should be 1000 but if it's not between 10500 and 16000 then divide the number by 10 and show that number.
I'm trying to convert it into a query in Access and if my assumption is correct then I should be on to a winner...cheers