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.

What is Amazon Go and will it come to the UK? The store without checkouts or queues

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

Hands-on with the Star Wars fighting drones you can fly yourself

iPhone 9 and beyond: 32 amazing future smartphone developments - graphene, supercapacitor…