Hi everyone,
A1 = 2 A2 = 3 A3= 4
A4 = A1+A2-A3 will show 1
B4 = A1-A2*A3 will show -10
what i need a simple formula for cells A5 & B5 .. n so on.. so that one can see what exactly done in cells A4 & B4
the -show formula option in excel does show the formula but that contains the cell names , but I need it with values.
like A5 =2+3-4 B5 = 2-3*4 the solution should work for all complicated calculations like trigonometry, inbuilt use of functions, etc..
"&A1&"... these kind of solution not gonna help me as I have thousands of formula in rows and I cant write it for all of them
same for concatenation it will not serve my objective..
please help thanx in advance
Bookmarks