blimey Posted January 24, 2006 Share Posted January 24, 2006 Hi, I'm trying to use an "If(logical_test,value_if_true,value_if_false)" function in a worksheet. I refer to the syntax of the manual, so I've got for example : value 7 in cell A1 value "if((A1=7),A1,0")in cell B1 I expect to get 7 as a result in B1 yet I only get my formula recopied... I don't get it... Any clue? Quote Link to comment
MullinRJ Posted January 25, 2006 Share Posted January 25, 2006 Hi LiMei, Put an equal sign in front of the formula to make it calculate. =if((A1=7), A1, 0) Raymond Quote Link to comment
blimey Posted January 25, 2006 Author Share Posted January 25, 2006 Hi Raymond, sorry, I mistyped, I did put an equal sign. When I enter "=if((A1=7), A1, 0" in B1, it writes "=if((A1=7), A1, 0" in the cell. It does not treat it as a function... Also, if I make a data base listing e.g. all the rectangles of the drawing, if I enter =Area, it returns the area of each listed rectangle, but if I ask for =Area(B1>100), it does not return (as I expected) the area of the corresponding rectangle if B1 is superior to 100, but it does return "true" or "false" according to whether or not my condition is fullfiled... Quote Link to comment
islandmon Posted January 25, 2006 Share Posted January 25, 2006 As noted by MullinRJ , the formula in cell B1 : =IF((A1=7), A1, 0) results: 7 no problem. The issue is the ' " ' behind the 0... delete it and use a trailer instead. Quote Link to comment
islandmon Posted January 25, 2006 Share Posted January 25, 2006 Note the spaces before 'A' & '0' =IF((A1=7), A1, 0) Quote Link to comment
ccroft Posted January 26, 2006 Share Posted January 26, 2006 This is odd. On my system it works as expected with or without spaces in the formula, and with or without the brackets around A1=7. In fact the only way I can get the formula to display as text is to put a space in front of =. I don't see a space in front of LMT's example...Have you tried a restart and a fresh new doc? In your database header this: =IF(AREA>100, AREA, 0) should do what you want. Quote Link to comment
blimey Posted January 26, 2006 Author Share Posted January 26, 2006 Well, I don't get it?! That's exactly what I'm doing. Look : I copy paste your text in cell B1 and here is the result : Quote Link to comment
blimey Posted January 26, 2006 Author Share Posted January 26, 2006 Sorry the images are difficult to read. Here again : 1) what I enter 2) And the result What do you think? Quote Link to comment
blimey Posted January 26, 2006 Author Share Posted January 26, 2006 This is indeed very bizarre, I've sent the file to techsupport, I'll tell you what they say. I've tested with or without spaces : the result is the same. I have no space before the = sign... See (no spaces on the left, spaces on the right: As for the AREA formula, CCROFT's proposal alas does not work. The result is in B3. I've got a true/false value in C3 by entering the formula =AREA(AREA>0) I'll send that want to techsupport as well... Will let you know Quote Link to comment
blimey Posted January 26, 2006 Author Share Posted January 26, 2006 BTW, is anybody working on PC? Could that be the problem? Is there anyone who has dual platforms and could test this? Quote Link to comment
blimey Posted January 26, 2006 Author Share Posted January 26, 2006 HOURRAHH!!! I've found it : Thinking about dual platform. I just thought that I could test it on another PC. So did I. an on the other PC it worked... Then I opened the file in my computer and it reads : =IF((A1=6); A1; 0) if I use ; instead of , it works. Quote Link to comment
JMR Posted October 31, 2019 Share Posted October 31, 2019 Well well! This old thread saved my day. Using commas or dots did't work - but semicolon works! Why such hidden tricks....I was going nuts with my worksheets. Quote Link to comment
Amorphous - Julian Posted October 31, 2019 Share Posted October 31, 2019 Good to know about this. Hopefully the engineers at Vectorworks will change this for the dual-platform users. On the note of the IF function, we find that this logic test only works for 15 levels. Anything behind that doesn’t work. Has anyone managed to go beyond 15 levels of it? Quote Link to comment
JMR Posted November 1, 2019 Share Posted November 1, 2019 If I may, how does one build levels into the IF function? Quote Link to comment
M5d Posted November 2, 2019 Share Posted November 2, 2019 (edited) I think Julian means nested, or something like this: =IF((A1=1), 'Red', IF((A1=2), 'Blue', IF((A1=3), 'Green', IF((A1=4), 'Yellow', IF((A1=5), 'Orange', IF((A1=6), 'Purple', '?')))))) Though, I thought the limit was 7. Edited November 2, 2019 by M5d Quote Link to comment
JMR Posted November 4, 2019 Share Posted November 4, 2019 Interesting, thanks! I didn't know one could do that. Quote Link to comment
Amorphous - Julian Posted November 4, 2019 Share Posted November 4, 2019 Yes thats right... And we can only achieve 15 levels of the above. 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.