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
Thanks,
Mr Singh
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
NUMERATOR | DENOMINATOR | NUMERATOR/DENOMINATOR * 1000 |
0 | 0 | -1 |
0 | 50 | 0 |
250 | 1250 | 200 |
50 | 0 | -1 |
Thanks,
Mr Singh
Last edited: