Hi Please Help me
I have a Formula that returns either 0,1 or 2 in Cell F6 deoendant on the Value of Cell C6 as shown below.
=IF(AND(C6>8.57,C6<8.59),0,IF(C6<8.56,1,IF(C6>8.59,2,)))
I need to be able to have Cell F6 empty if Cell C6 is empty but cant get it to function. Any help would be wonderfull
Thanks in advance
Cheers
Bob
=if(or(istext(c6),c6=""),"",if(c6>8.59,2,if(c6>8.57,0,1)))
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
Thankyou so much Sisthsence you have saved what little Hair I have left
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks