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

OnePlus 5 review

Alice Saey's mesmerising animation for Dutch singer Mark Lotterman

iPad Pro 10.5in (2017) review

Comment booster votre iPhone ?