3/9/2023 0 Comments Openoffice or libreoffice 2017if my wardrobe is more than 3m i need 2 x 2m lengths of light.if my wardrobe is more than 2m but less than 3m I need a 2m and a 1m length of light.if my wardrobe is 2m or less I need a single 2m length of light.My wardrobes can be between 1.2m and 4m long. My lights come in strips of 1 metre or 2 metre lengths that can plug together and be cut to fit shorter lengths. I need to order a different number of lights depending on the width of the wardrobe. We sell bedroom wardrobes and I’m creating a spreadsheet that given a particular width will work out which component parts we need to order. Here’s a real example I’ve just had to figure out for my work. I often find myself wanting to do something more clever than that though. If we put anything else inside A1 (‘six’,7,true,false,or even leave it empty) then B1 is displayed as “Not 6” Using ‘between’ or ‘and’ in our if statements Then put ‘6’ inside A1, B1 is displayed as “I see the number 6” If our test_something returns false, then calculate the do_if_thats_false section.Įxample if we put this formula in cell B1 =if(A1=6,"I see the number 6","Not 6") If our test_something is true, calculate the do_if_thats_true section. Test_something has to return true or false, so we can have if we have cell A1 with value of 6, A1=6 would return true whereas A1=5 would return false and A1=”six” would return false (the written six is not the same as the number 6). Like “IF a number is between 20 DO this ELSE that” First, a little background on simple if statementsĪn if statement in calc is written: =if(test_something,do_if_thats_true,do_if_thats_false) Today I looked at lots of other forumulas and found one that let me create an if_between effect. It’s always annoyed me when I want to write an if statement where true is based upon more than one fact and I have to nest if statements.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |