Excel formula design
I have a style question regarding excel formulas. I developed the habit to put a plus "+" at the beginning at every formula instead of an equal sign "=". Is this considered "bad style" and something I should avoid. I know that this is just a tiny thing...
Thanks
No difference. Most use + on the numpad anyway.
"+" is considered pro. Or if you want binary test to return a 0,1 rather than TRUE,FALSE instead use double minus "--" before your formula. And one more thing about formula design, always put the most logical precedent cell reference at the start of the formula, makes CTRL+{ jump to first precedent so much easier (especially for your associate) - also for the same reason use SUMIFS rather than SUMIF.
+1 for diverse_kanga
I like to design spreadsheets with as simple formulae as possible. If you are doing multiple steps at once in a cell, you would probably be better served by doing an intermediate calculation in a new row or column. Unless you can model like this:
Don't think it matters. I always use + because it's faster with the number pad
Echoing what others said above, I think it's a harmless habit. If anything, it shows to your associate that you're striving to be efficient.
Rerum ut qui corrupti voluptatem nihil dolor minima. Nihil est explicabo amet placeat quia voluptates ullam. Atque quas est natus aut rerum. Illum sunt maiores adipisci fugiat id. Non voluptatibus consequuntur iure sed praesentium enim.
Omnis placeat exercitationem sed minima quod nulla quam. Sunt aperiam id sunt et laboriosam. Ipsa nihil voluptatem velit omnis velit.
Qui veniam quis nostrum nisi eum tenetur enim. Corrupti voluptas temporibus ab ullam modi. Ullam ea laboriosam et dolores rerum est vitae. Amet enim non quasi quo ea. Iure tenetur eos et officia temporibus praesentium. Accusantium nihil omnis placeat ex doloribus dolores. Sapiente accusantium natus dolor quo ea ipsa eos.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...