How to build a (simple) complex mathematical formula?

3vangelica

New member
Joined
Aug 28, 2017
Messages
1
Reaction score
0
Points
0
This may not be as complex as I think but, I sure could use some help figuring it out.

So, I need: (1st Cell) + (2nd Cell x 10) + (3rd Cell x 100) + (4th Cell x 1000)

Is this possible?

Thanks for any and all help :)
 
Last edited:
Hi and welcome
something like =A1 + a2*10+ A3*100 + A4*1000
Depending on layout and other factors this can be shortened
 
Another way

=SUMPRODUCT(A1:A4*10^(ROW(INDIRECT("A1:A4"))-1))
 
Back
Top