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.
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"
=IF(G25=24;"Double";"")
=IF(G25=7;"Ground out";"")
=IF(G25=24;"Double";IF(G25=7;"Ground out";""))
If i do the nested example you provided, can i have 4 or 5 "If" commands?
=IF(The Condition;Output when it is True;Output when it is False)
[Tutorial] VLOOKUP questions and answersBrevardo wrote: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] Ten concepts that every Calc user should knowBrevardo wrote:Any help is greatly appreciated.
Users browsing this forum: Majestic-12 [Bot] and 33 guests