route217
asked on
Error in formula not increasing value
Hi Experts using excel 2010
Using the following formula
B6 =K6&"--"&TEXT($B$1,"00000" )
B7 =K6&"--"&TEXT(RIGHT($B6,5) +$B$1),"00 000")
Cannot get the B7 one to work....
Using the following formula
B6 =K6&"--"&TEXT($B$1,"00000"
B7 =K6&"--"&TEXT(RIGHT($B6,5)
Cannot get the B7 one to work....
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER