Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
"IF,THEN, DO) any help
I am an old Lotus 123 user. Help, I need a IF THEN DO to work for me on a
spread sheet, any info. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
"IF,THEN, DO) any help
I'm not sure I fully understand, not having used Lotus. But if you are just trying to have a cell value populated under several conditions (if x is true, make the cell value this, if x is not true, make the cell value that), the format is: IF(condition to test,value if true, value if false) You can nest up to 7 IFs. -- BruceP ------------------------------------------------------------------------ BruceP's Profile: http://www.excelforum.com/member.php...o&userid=33653 View this thread: http://www.excelforum.com/showthread...hreadid=535775 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|