"If text then give random number" query

[tomh4]

Hi. I think I'm nearly there on the IF function but not quite. I want a function that says if a given cell contains a certain text phrase, then choose a random number between x and y, and if it doesn't then choose from a different range. Does that make sense and is it possible?

Thanks,

Tom

 

[Snakehips]

Do you mean something like this in say B2...

=IF(A2="This Text",RANDBETWEEN(1,5),RANDBETWEEN(6,10))

Hope that helps.

 

[tomh4]

Perfect Snakehips thanks. I was putting "" around the RANDBETWEEN functions. I knew I was close!

Thanks