I know that if we want to combine two conditions (upto 7) inside IF command,
we have to use nested IF, like: IF(a1>1(IF(a2<2,...),...)
Just out of curiasity, is it possible to use command "AND" inside IF for
combination of conditions?
--
Rasoul Khoshravan Azar
Kobe University, Kobe, Japan
Absolutely!!!
=if(and(a1>1,a1<10),a1*100,0)
---------------------------------------------------
ONLY APPLIES TO VBA RESPONSES WHERE APPROPRIATE
To insert code into the VBE (Visual Basic Editor)
- Copy the code.
- Open workbook to paste code into.
- Right click any worksheet tab, select View Code
- VBE (Visual Basic Editor) opens to that sheets object
- You may change to another sheets object or the This Workbook object by double clicking it in the Project window
- In the blank space below the word "General" paste the copied code.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks