[Solved]Trying to move the results of a RAND function

[Brevardo]

I have a formula for creating a random number in a cell. Now i would like to execute the formula each time so when it calculates the random number i can have it show up in a stand alone cell. The reason i want to do this is because each time i calculate it or execute the command i will see a different number between 1 and 30. I then want to be able to create a new command such as IF that will say, "if g 25 = 24, "Double" or "if g25 = 7, "Ground out" Any help is greatly appreciated. Thanks

[Zizi64]

Now i would like to execute the formula each time so when it calculates the random number i can have it show up in a stand alone cell.

You can not COPY a value by a FORMULA. A formula will REFERENCE the value.
Copy it manually or write a macro for this task.

I then want to be able to create a new command such as IF that will say, "if g 25 = 24, "Double" or "if g25 = 7, "Ground out"

Code: Select all

=IF(G25=24;"Double";"")

Code: Select all

=IF(G25=7;"Ground out";"")

And you can use combined (nested) the IF statements too.

Code: Select all

=IF(G25=24;"Double";IF(G25=7;"Ground out";""))

[Brevardo]

Okay. This is good info. If i do the nested example you provided, can i have 4 or 5 "If" commands? The only thing that confused me was the parentheses. How many would I need to have in the formula if say I use 5 "If" commands? Thanks

[Zizi64]

If i do the nested example you provided, can i have 4 or 5 "If" commands?

Yes you can. See the Help.

Code: Select all

=IF(The Condition;Output when it is True;Output when it is False)

You can insert a new IF() into the output places of a formula.

But it is better to use a helper table and the function VLOOKUP() instead of the nested IF() - when you want to use more than 3-4 conditions for same input parameter.

[Brevardo]

Okay. That makes sense. Let me go ahead and try that and Ill keep you posted. Thanks again

[RusselB]

If you have a lot of conditions that you want to have specific messages for, then using a table and the VLOOKUP function, as I now see Tibor already suggested.
The table option would also allow quick changes, additions and deletions if the messages and/or number of messages changed.

[MrProgrammer]

I then want to be able to create a new command such as IF that will say, "if g 25 = 24, "Double" or "if g25 = 7, "Ground out"

[Tutorial] VLOOKUP questions and answers

If this solved your problem please go to your first post use the Edit button and add [Solved] to the start of the title. You can select the green checkmark icon at the same time.

Any help is greatly appreciated.

[Tutorial] Ten concepts that every Calc user should know