Home |
Search |
Today's Posts |
#1
|
|||
|
|||
More than 7 IF(AND) statements
How can I get more than 7 IF(AND) statements??? -- alexm999 ------------------------------------------------------------------------ alexm999's Profile: http://www.excelforum.com/member.php...fo&userid=4918 View this thread: http://www.excelforum.com/showthread...hreadid=390076 |
#2
|
|||
|
|||
try http://www.cpearson.com/excel/nested.htm -- Bryan Hessey ------------------------------------------------------------------------ Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059 View this thread: http://www.excelforum.com/showthread...hreadid=390076 |
#3
|
|||
|
|||
i have a massive formula which i want to have a name for but i cant copy it
into the 'refers to' field. how do i put the formulas in for naming? "Bryan Hessey" wrote: try http://www.cpearson.com/excel/nested.htm -- Bryan Hessey ------------------------------------------------------------------------ Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059 View this thread: http://www.excelforum.com/showthread...hreadid=390076 |
#4
|
|||
|
|||
With the cell containing the fomula selected, Insert, Name, Define, and name the item. Had you considered entering your formula into multiple helper columns, to assist you in that it would reduce the level of complexity and the results from various stages of calculation could be checked. These helper columns can remain hidden once the formula is working. Micayla Bergen Wrote: i have a massive formula which i want to have a name for but i cant copy it into the 'refers to' field. how do i put the formulas in for naming? "Bryan Hessey" wrote: try http://www.cpearson.com/excel/nested.htm -- Bryan Hessey ------------------------------------------------------------------------ Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059 View this thread: http://www.excelforum.com/showthread...hreadid=390076 -- Bryan Hessey ------------------------------------------------------------------------ Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059 View this thread: http://www.excelforum.com/showthread...hreadid=390076 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|