Hi guys,
I want to ask this.
In Excel =if() function, I can have if certain condition is true then I get a value from a certain cell, otherwise I get another value from another cell.
How about I have 6 different input cells, and 6 different conditions, feed in to one cell. Like if the condition is 1 then I feed target cell with value from cell 1. And if the condition is 2 then I feed the only target cell with value from cell 2.
The cell can handle multiple different conditions?
Thanks.
You can use nested IF statements (up to 7 using normal methods in Excel 2003 and earlier). For example:
This says:
=IF(A1=1,A10,IF(A1=2,B10,IF(A1=3,C10,D10)))
If cell A1 equals 1, return the value in cell A10; otherwise
If cell A1 equals 2, return the value in cell B10; otherwise
If cell A1 equals 3, return the value in cell C10; otherwise
Return the value in D10.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks