calculations

[Guest]

Hello everyone,

I'm stuck on a calculation I need for this worksheet on working on? I need a formulas that states the following:

if a user input a 1 in a cellA then cellB will display a value of 4, but for every number more than 1 in cellA, cellB needs to add an additional 2 to the original value (4). So, if someone enters in 3 in cellA, celllB should display 8. I hope this makes sense. Any help would be wonderful, i have been banging my head against the wall all morning.

thanks in advance,
Mike

 

[Norman Harker]

Hi Mike!

Stop damaging the wall! <vbg>

Use:

=4+(A1-1)*2

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.

 

[Frank Kabel]

Hi Mike
try
=IF(A1>=1,4+(A1-1)*2)

--
Regards
Frank Kabel
Frankfurt, Germany

Hello everyone,

I'm stuck on a calculation I need for this worksheet on working on?

I need a formulas that states the following:

if a user input a 1 in a cellA then cellB will display a value of 4,

but for every number more than 1 in cellA, cellB needs to add an
additional 2 to the original value (4). So, if someone enters in 3 in
cellA, celllB should display 8. I hope this makes sense. Any help
would be wonderful, i have been banging my head against the wall all
morning.