Link to home
Create AccountLog in
Avatar of Jenkins
JenkinsFlag for United States of America

asked on

Excel formula to check for certain values in a cell

Using Excel:

cells A1, B1 and C1 are all defined as numeric.

I need a formula to be placed in Cell C1 that will perform the following (in plain English):

If (the value in cell B1 is less than the value in A1) or (the value in A1 is equal to zero) then set the value of C1 to zero. Otherwise, divide B1 by A1 and place the ROUNDED result of that calculation in cell C1.  Thank you.
ASKER CERTIFIED SOLUTION
Avatar of byundt
byundt
Flag of United States of America image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.