Forum Discussion
Solved
If than Formula.
If I want to run a formula that is IF cell E1 is less than 0, than 0, if greater than, then e1/d1 what would it look like. Thanks for any help as I am not great with IF than formulas.
The formula would return #DIV/0! if D1 equals 0, not if E1 equals 0.
Perhaps
=IF(OR(E1<0,D1=0),0,E1/D1)
Solved thank you. I appreciate the assistance everyone. Thank you
