Help...
I am trying to combine formula that I currently have to compute the following:
IF(N4<4,"N/A",IF(AND(N4>3,N<10,IF(O4=0,"A",IF(O4=1,"C","D"))))
IF(N4<4,"N/A",IF(N4>9,IF(O783=0,"A",IF(O783=1,"B",IF(O783=2,"C","D"))))
Is there a way to combine these 2 into 1?
1st Equation = N4>3 AND N4<10
2nd Equation = N4>9
That mean 9.1 till 9.9 can fall in between 2 equation.Unless you dont have decimal.
Try this.
Please Login or Register to view this content.
-If the problem is solved, please mark your thread as Solved: Click Thread Tools above your first post, select "Mark your thread as Solved".
-Always upload a workbook before start your question
To attach a file, push the button with the paperclip (or scroll down to the Manage Attachments button), browse to the required file, and then push the Upload button.
+++ If my answer(s) helped you, please add me reputation by click on * +++
You are my hero, thank you
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks