• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

excel formula help - IF THEN ELSE STATEMENT

jk51

Member
Hi,
Need help on excel formula in column c for all the conditions in 1.
IF NUMERATOR AND DENOMINATOR both 0 THEN "-1"
IF (NUMERATOR = 0) AND (DENOMINATOR > 0) THEN "0"
IF NUMERATOR AND DENOMINATOR both > 0 THEN CALCULATE N/D * 1000
IF (NUMERATOR > 0) AND (DENOMINATOR = 0) THEN "-1"

See table below:
NUMERATOR is cell A1, DENOMINATOR is cell B1 and N/D * 1000 is cell C1

NUMERATORDENOMINATORNUMERATOR/DENOMINATOR * 1000
00-1
0500
2501250200

500-1

Thanks,

Mr Singh
 
Last edited:
Back
Top