EXEL GREATER THAN FORMULA

  peug417 20:38 20 Feb 05
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 05

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.

Huawei P10 review

1995-2015: How technology has changed the world in 20 years

How Nearly Normal created super-fun papercraft for Google

47 iPhone camera tips to help you take better photos