Could someone show me an example of a formula that adds and mutiplys in the same cell?
R RickComputer Oct 13, 2008 #1 Could someone show me an example of a formula that adds and mutiplys in the same cell?
T Tom Hutchins Oct 13, 2008 #2 If A1 = 4, A2 = 5, and A3 = 6: =A1*(A2+A3) adds A2 + A3, then multiplies the result times A1. 4*(5+6) = 44 Hope this helps, Hutch
If A1 = 4, A2 = 5, and A3 = 6: =A1*(A2+A3) adds A2 + A3, then multiplies the result times A1. 4*(5+6) = 44 Hope this helps, Hutch
R RickComputer Oct 13, 2008 #3 Thank You That answers my question. Tom Hutchins said: If A1 = 4, A2 = 5, and A3 = 6: =A1*(A2+A3) adds A2 + A3, then multiplies the result times A1. 4*(5+6) = 44 Hope this helps, Hutch Click to expand...
Thank You That answers my question. Tom Hutchins said: If A1 = 4, A2 = 5, and A3 = 6: =A1*(A2+A3) adds A2 + A3, then multiplies the result times A1. 4*(5+6) = 44 Hope this helps, Hutch Click to expand...
