Questions & Answers for: Microsoft Excel error a1

recommend always creating the first formula manually by selecting the cells. This will avoid common errors like extra spaces

...Error method " Thanks for help In A1, put a random value of d as 0.1. Then in B1, put your equation 5*d^4 - 10.29*d^(-1.333), wherein refer d as A1. Then use goal seek function on Tools Menu. First ...

...With this you must have 1, 2, or 3 in A1 or you will get a #VALUE error in B1. I came up with this: =IF(A1=1,"Good",IF(A2=2,"Fair",IF(A3=3,"Bad","Wrong"))) Works fine for

error or having to use a second cell just for the ''I'' Basically if I put I001 in cell A1 cell B1 must automatically Be I002 There are roughly 50 that must be done like this in +1 increments from the