schoeller Posted September 17, 2003 Share Posted September 17, 2003 to use the if condition what is the exact way to refer to a value in a cell: =if(B2=sresrere;paint;not paint) is correct?? when using this only true or false appear Quote Link to comment
Vectorworks, Inc Employee Robert Anderson Posted September 17, 2003 Vectorworks, Inc Employee Share Posted September 17, 2003 Use commas, not semicolons, to separate your terms. Quote Link to comment
schoeller Posted September 17, 2003 Author Share Posted September 17, 2003 i am not sure can you write an exemple on a worksheet withe te "if" condition on a value of the woksheet thanks Quote Link to comment
Vectorworks, Inc Employee Robert Anderson Posted September 17, 2003 Vectorworks, Inc Employee Share Posted September 17, 2003 Make a worksheet two cells wide. In the right cell of the first row, type: =IF(A1>3, 'Red', 'Blue') Now when you enter a value greater than 3 in cell A1 (the upper left cell), the value of the formula cell will change. Quote Link to comment
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.