ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   "IF,THEN, DO) any help (https://www.excelbanter.com/excel-worksheet-functions/84982-if-then-do-any-help.html)

Dumbo

"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.

BruceP

"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



All times are GMT +1. The time now is 04:24 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com