Jenkins

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.

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

membership

Create an account to see this answer

Signing up is free. No credit card required.

This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.