Format Cell

[Troy]

I have 3 problems:

1. I make a custom format ###,###.## but the . always
appears, if there are no 10ths or 100ths I don't want
the . to appear.

2. I have this formula =IF(AND($AC7>18,$X7>0),IF(ISERROR
(SUM($AC7/(VLOOKUP($X7,$I$9:$U$89,13,FALSE)))),"",SUM
(ROUNDDOWN($AC7/(VLOOKUP($X7,$I$9:$U$89,13,FALSE)),0))),"")
If the value is 13.9999 it will display 14. I always want
it to round down, but it won't.

3. I have a sheet for my daughters spelling. Cells Z6:AG40
contain words in them. I want cell A6 to randomly pick one
of the words in Z6:AG40.

 

[JE McGimpsey]

2. One way:

=IF(AND($AC7>18,$X7>0),IF(ISNA(MATCH($X7,$I$9:$I$89,FALSE)),"",
TRUNC($AC7/VLOOKUP($X7,$I$9:$U$89,13,FALSE))),"")

3. One way:

=INDEX(Z6:AG40,RAND()*35+1,RAND()*7+1)

 

[Troy]

On this formula =INDEX(Z6:AG40,RAND()*35+1,RAND()*7+1

I had words repeat, this there any way to prevent this

Also, is there a solution to my ###,###.#### question?

 

[JE McGimpsey]

In order to do what you're after requires VBA. Do you want to try that?
If so, you need to add some additional information. Are you using only
one cell? If so, how do you want to trigger the change? If not, where
should the results be placed?