Need Help Please with Excel Formula

Lindee

New Member
Joined
Jan 27, 2018
Messages
24
just a thought but aside from what you are looking for try typing this in any cell

=RANDBETWEEN(100,999)

this will generate a random 3 digit number just press the F9 Key to get a new number
Used your formula and I'm testing now. It may turn out to be helpful. Thank you again
I
 

Some videos you may like

Excel Facts

Create a Pivot Table on a Map
If your data has zip codes, postal codes, or city names, select the data and use Insert, 3D Map. (Found to right of chart icons).

Lindee

New Member
Joined
Jan 27, 2018
Messages
24
Your welcome.....I'm thinking 20 - 30% of any winning lol
Good enough for me Thank you again,,,,
I found this formula on another site:
"In A1, enter the number 10.
In A2, enter the formula =A1+1. Fill down to A90.
In B1: =TEXT(A1,"00")&RIGHT(TEXT(A1,"00"),1)&LEFT(TEXT(A1 ,"00"),1)
Fill down.

--
Kind regards,

Niek Otten"

Wanted to give the guy his credit. Maybe you can use it.
Good Luck
Linda
 

Lindee

New Member
Joined
Jan 27, 2018
Messages
24
Hey Marcelo Branco,,,,I found a resolution to the issue of not being able to post the formula in the cells....I pasted the formula in the cell, then went to the formula bar, took out the = sign from the formula, then put the = sign in again and it WORKED it excepted the formula....I figured it out on my own ,,,very simple. Incase you have someone with the same issue. Still have the "Value Error" but that's ok, I found another formula... Thank you again for all your hard work.
Sincerely Linda
 

Marcelo Branco

MrExcel MVP
Joined
Aug 23, 2010
Messages
16,371
Linda,

I'm glad you found a solution to your problem.
Greetings

M.
 

Lindee

New Member
Joined
Jan 27, 2018
Messages
24
Hey Marcelo Branco,,,,I found a resolution to the issue of not being able to post the formula in the cells....I pasted the formula in the cell, then went to the formula bar, took out the = sign from the formula, then put the = sign in again and it WORKED it excepted the formula....I figured it out on my own ,,,very simple. Incase you have someone with the same issue. Still have the "Value Error" but that's ok, I found another formula... Thank you again for all your hard work.
Sincerely Linda
M, just wanted to update you with Great News,,, I was working with your formula,, I got it to work by changing the formating to General,,, used the little trick of removing the = sign and then replacing it in the formula bar and IT is now working GREAT. just wanted you to know you were on the right track. I used the evaluate formula when I posted it in the cell and Excel 10 said the cell was a "constant" (whatever that means) so I changed to General formatting.
Thank you M.
NEVER GIVE UP!!! that comes from
my Scottish heritage.
Thank you so much. I'd give you a hug but your a little to far away. lol
Linda PS. I would have never known any of this, if it wasn't for you and your patience.!!!!!!!(y)
 
Last edited:

Marcelo Branco

MrExcel MVP
Joined
Aug 23, 2010
Messages
16,371
Linda,

Great news!

I'm very happy that the formula i suggested is working now and you figured out how to enter formulas.

All the best

M.
 

Watch MrExcel Video

Forum statistics

Threads
1,095,320
Messages
5,443,770
Members
405,251
Latest member
shanezer

This Week's Hot Topics

Top