Hi everyone,
I'm sure there's a very simple solution here, so don't laugh
I just wondered why this formula isn't working (Column O), & how I'd be able to calc it properly
d_TWqVwnSMuBDiTofNURbQ.png
Basically,
true -> if the number (C3) falls between 2.36 - 2.76 or 2.9 - 3.0
Should be dead simple!
Thanks
Mdn
=IF ( OR ( AND ( C3 > = 2.36 , C3 < = 2.76 ) , AND ( C3 > = 2.9 , C3 < = 3 )) , 1, "" )true -> if the number (C3) falls between 2.36 - 2.76 or 2.9 - 3.0
=IFERROR(IF(OR(AND(C3>2.36,C3<2.76),AND(C3>2.9,C3<3)),1,""),"")
will there be an error in C3 ?
Last edited by etaf; 02-20-2019 at 07:49 PM.
Wayne
if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here
If you have a solution to your thread - Please mark your thread solved do the following: >
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
That's bril Etaf, many thanks!
you are welcome
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks