Hello,
I need help coming up with a formula to put in B1 that will do the follow:
If the amount in A1 is less than 400, I want B1 to equal A1
If the amount in A1 is between 400 and 800, I want B1 to be 400
If the amount in A1 is greater than 800, I want B1 to be A1/2
Thank you so much for you help!
I need help coming up with a formula to put in B1 that will do the follow:
If the amount in A1 is less than 400, I want B1 to equal A1
If the amount in A1 is between 400 and 800, I want B1 to be 400
If the amount in A1 is greater than 800, I want B1 to be A1/2
Thank you so much for you help!