Excell formula

Closed
Report
-
Posts
2829
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
November 22, 2021
-
Hello, i am trying to find a formula so that if i put a value in cell a2 and a valu

e in cell a3 then i want in cell a1 it to produce a value eg a1 will be the total a2 1 was sold which would have a value of £80 and a3 2 was sold so it will produce a value of £200 so a1 would total £280, but i need this to work with increasing numbers so if cell a3 value was 10 and a2 was 1 the vale in a1 would be 1080. any help would be great i have been trying this for 4 day's

thanks

simon

1 reply

Posts
2829
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
November 22, 2021
490
Hi Gutty,

Try this formula:
=A2*80+A3*100

Is this what you were looking for?

Best regards,
Trowa