| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
changing value
Hiya guys and gals i need to make my cell m20, the same value as the last figure entered in cells a20:n20. eg. if a20 =200, B20=400, C20=800 and the rest are blank then N20 should be 800 hope i have explained this okay  Regards James -- superkopite ------------------------------------------------------------------------ superkopite's Profile: http://www.excelforum.com/member.php...o&userid=29496 View this thread: http://www.excelforum.com/showthread...hreadid=492006 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Changing format of number without changing the value | Excel Discussion (Misc queries) | |||
| how do i replace ( with / without changing format to fraction | Excel Worksheet Functions | |||
| Changing the format of an Excel output file made by Microsoft Access | Excel Discussion (Misc queries) | |||
| How do I stop excel automatically changing my date to 2005? | Excel Discussion (Misc queries) | |||
| changing page break in an excel file | New Users to Excel | |||
Threaded Mode
