EXEL GREATER THAN FORMULA

  peug417 20:38 20 Feb 2005
Locked

I HAVE THE FOLLOWING FORMULA IN A CELL "=IF($E$30="","",IF(AND($E$30>4999,$I$30="2 YEARS"),$E$30*$G$7/1000,0))" THIS WORKS FINE BUT I WANT TO INCREASE TO >4999 AND 9999 BUT CANT FIGURE IT OUT!ANY HELP FROM YOU WHO KNOW WOULD BE APPRECIATED

  peug417 21:19 20 Feb 2005

having meddled for a bit i worked out i needed and = IF(AND(OR Statement so the formula i came upon was .....
=IF($E$30="","",IF(AND(OR($E$30>4999),($E$30<9999),$I$30="2 YEARS"),$E$30*$G$7/1000,0))

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

Best Black Friday Deals 2017

Black Friday Deals for Designers & Artists: Adobe, Apple, Corel Painter, Microsoft Surface, Wacom &e…

Best Black Friday Apple Deals 2017

Black Friday 2017 : date, sites participants & bonnes affaires