LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
rlrlatr35
 
Posts: n/a
Default How do figure excel formula out?

I'm taking an excel class & the ? is "if you enter 5B21C2 in cell B1 of a
worksheet the formula is replaced by the # 125 when you press enter. What
happened? The worksheet is hypethetical. Then the next ? is to use same
worksheet, change the # in cell B2 from 55 to 65. What happens to the # in
cell B1 & why. The info I found doesn't tell how to figure the first formula
so everything else doesn't make sense to me. HELP!
--
thanks

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to I use ** without Excel thinking I want to type a formula? Buff Excel Discussion (Misc queries) 2 December 22nd 04 09:31 PM
Converting an Excel formula to an Access query formula Adam Excel Discussion (Misc queries) 1 December 15th 04 03:38 AM
I cant seem to figure out how to use Proper in excel. The help op. deborahpib Excel Discussion (Misc queries) 1 December 14th 04 06:54 PM
Excel: To Display Formula in the cells Instead of Value [email protected] Excel Discussion (Misc queries) 1 December 10th 04 09:48 PM
Preserve Excel formula entry MHoffmeier Excel Discussion (Misc queries) 5 December 2nd 04 06:34 PM


All times are GMT +1. The time now is 02:16 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"