# I am trying to figure out the excel function, see attachment.

Copper Contributor

# I am trying to figure out the excel function, see attachment.

These accounts are hitting both of my reports and I only want to charge the accounts \$10 if their balance is below \$1000 but greater than \$300. I hope this makes sense. My function may not be correct to fit the outcome I am trying to accomplish.

2 Replies

# Re: I am trying to figure out the excel function, see attachment.

See the attached. I think what you actually want is an =IF(AND(... formula rather than an =IF(OR(...

=IF(AND(B2>300,B2<1000),10,0)

This way of doing it gets the result 10 if the number is between 300 and 1000.

Using the OR doesn't screen out anything; it gets any and all results greater than 300 as well as any and all numbers less than 1000. Which is to say, everything!

I've attached your spreadsheet modified to show the results of two formulas.

You would do well to become familiar with this website, to research well written and practical examples of any function.

# Re: I am trying to figure out the excel function, see attachment.

Thank you for the example, that worked just fine!