Excel Basics #3: Formulas w Cell References

25 Responses to “Excel Basics #3: Formulas w Cell References”

1. ExcelIsFun on: 3 March 2010 at 2:29 pm

   Sorry about that! I’ll try to do better next time!
2. impatientp on: 3 March 2010 at 3:17 pm

   I take it back… it must just be how you speak
3. ExcelIsFun on: 3 March 2010 at 3:59 pm

   You are welcome very much!! Helping people is good.
4. icemantet on: 3 March 2010 at 4:19 pm

   thank you very much.you help a lot lof people on doing this.keep up the good work
5. ExcelIsFun on: 3 March 2010 at 5:02 pm

   You are welcome!!
6. fahadsaeed50 on: 3 March 2010 at 5:16 pm

   good job thanks for uploading
7. ExcelIsFun on: 3 March 2010 at 5:26 pm

   I am glad that the dancing ants can take the Excel phobia and throw it out the door!
8. amycecillau on: 3 March 2010 at 6:00 pm

   by the way, dancing ants, LOL! you took the excel phobia out of all of us. Thanks.
9. ExcelIsFun on: 3 March 2010 at 7:00 pm

   Those are awesome keyboard tricks for when the range is highlighted!
10. gastonytHQ on: 3 March 2010 at 7:15 pm

    Ctrl + D
    and
    Ctrl + R
    also help as quick Formula Copy.
11. ExcelIsFun on: 3 March 2010 at 7:17 pm

    Watch this video title for how Conditional Formatting works:

    Highline Excel Class 21: Conditional Formatting 12 Examples

    Then if warning is in cell A1, the TRUE/FALSE formula you want in the Conditional Formatting dialog box is:

    =A1=”WARNING”
12. jelu95 on: 3 March 2010 at 7:58 pm

    Hi could you tell me please how can I append properties to a cell. If I have a formula in a cell which will make the word WARNING appear, how can I make that word appear in a different cell colour, font and size) How can the formula be instructed that these changes appear on the word when its suppose to pop up. Thank you
13. ExcelIsFun on: 3 March 2010 at 8:09 pm

    Both do work, but it takes more keys to enter:

    =SUM(-E2,B2)

    than it does to enter:

    =B2-E2

    Fewer keys = saved time.

    But if you learned spreadsheets back in the days of Lotus and VisiCalc, you probably learned to do all formulas inside the SUM function.
14. thirthyest on: 3 March 2010 at 8:27 pm

    how about =SUM(-E2,B2)
    instead of =B2-E2
    
15. ExcelIsFun on: 3 March 2010 at 9:12 pm

    Dear slaves2sin,

    Yes, Shift + Enter is a great one, if you like keyboard shortcuts!

    –excelisfun
16. slaves2sin on: 3 March 2010 at 9:39 pm

    great i learned the shift + enter to go up
17. ExcelIsFun on: 3 March 2010 at 9:50 pm

    Dear maesbrit ,

    EXCELlent! I am glad that it helped. Did you download my free book too? It has some great pages about cell references and formulas.

    –excelisfun
18. maesbrit on: 3 March 2010 at 10:20 pm

    Wow, I think I get it now, lol. Thanks! The downloadable worksheets made the difference. I will be passing this page on the other students!
19. ExcelIsFun on: 3 March 2010 at 10:47 pm

    Dear coolshit28 ,

    I am glad that they are helpful!

    –excekisfun
20. coolshit28 on: 3 March 2010 at 11:05 pm

    Thanks dude – very helpful!!
21. ExcelIsFun on: 3 March 2010 at 11:59 pm

    Dear Indierkgrl,

    You are welcome!

    –excelisfun
22. Indierkgrl on: 4 March 2010 at 12:51 am

    thank YOU, this was amazing
23. ExcelIsFun on: 4 March 2010 at 1:24 am

    Dear klmukesh ,

    You are welcome!

    –excelisfun
24. klmukesh on: 4 March 2010 at 1:47 am

    thank you very much for sharing it with all of us
25. ExcelIsFun on: 4 March 2010 at 1:53 am

    Dear Baobao531,

    I am glad that you like it!

    It saves a lot of time (compared to a calculator), if you know some Excel!

    –excelisfun