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: