| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
doubt
wht will the result of formula'=B2+$C$3' in c2 when copied to A3
|
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
doubt
Why don't you try, and let us know?
What would you expect it to be? What do you want it to be? If you don't understand what it's doing, look up absolute and relative addressing in Excel help. -- David Biddulph "nibu" wrote in message ... wht will the result of formula'=B2+$C$3' in c2 when copied to A3 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
doubt
On Aug 15, 2:30 am, nibu wrote:
wht will the result of formula'=B2+$C$3' in c2 when copied to A3 It will change one of those references into a #REF! error. Is this a silly-Excel-knowledge contest? Do I win the prize?!?! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel Doubt | Excel Discussion (Misc queries) | |||
| Macro doubt | Excel Discussion (Misc queries) | |||
| I have a doubt! | Excel Discussion (Misc queries) | |||
| Vlookup doubt.. | Excel Discussion (Misc queries) | |||
| some doubt | Excel Worksheet Functions | |||
Linear Mode
