= 1 if 0% < A2< 2:5% how do I do it in excel please
= 1 if 0% < A2< 2:5% how do I do it in excel please
What is the answer to the equation any why?
BSB
its for a research paper. I want to code cell 1 if the numbers are larger than 2.5% and smaller than 0%. do not know how
Welcome to the forum
Please try:
Formula:Please Login or Register to view this content.
Geoff
Did I help significantly? If you wish, click on * Add Reputation to say thanks.
If your problem has been resolved please select ?Solved? from the Thread Tools menu
you could try ... =IF(OR(A2<0,A2>2.5%),1,"")
Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
Sam Capricci
Glad it works for you! - thanks for the added reputation.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks