| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Really basic formula
Hi,
I am having trouble with what I am sure is a very simple formula: I want a formula to enter a number into cell B1 when I enter a number into cell B2, eg B2 = 5, and I want B1 to display 1005, with the range being from 1-501 that I will enter into B2, displaying in B1 1001-100501. I entered =if(B2=1,1001), which of course won't change as the data changes...... Thank you, |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Really basic formula
On Jul 4, 7:12 pm, BB wrote:
I am having trouble with what I am sure is a very simple formula: I want a formula to enter a number into cell B1 when I enter a number into cell B2, eg B2 = 5, and I want B1 to display 1005, with the range being from 1-501 that I will enter into B2, displaying in B1 1001-100501. =value("100" & b2) |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Really basic formula
Thank you so much! Works a treat!
"joeu2004" wrote: On Jul 4, 7:12 pm, BB wrote: I am having trouble with what I am sure is a very simple formula: I want a formula to enter a number into cell B1 when I enter a number into cell B2, eg B2 = 5, and I want B1 to display 1005, with the range being from 1-501 that I will enter into B2, displaying in B1 1001-100501. =value("100" & b2) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| basic formula | Excel Worksheet Functions | |||
| Basic Future Value Formula & Interest Rate Formula | Excel Discussion (Misc queries) | |||
| Another Basic formula I should know (but Don't) | Excel Worksheet Functions | |||
| Basic if formula | Excel Discussion (Misc queries) | |||
| Basic formula help | Excel Worksheet Functions | |||
Linear Mode
