Forum Discussion
I am trying to figure out the excel function, see attachment.
Can someone please help me with this excel function, see attachment? Thanks
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.
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.
- Thank you for the example, that worked just fine!
