Excel formula if equal to this but not equal to that number

[ibruzzi]

Hi
I tried to write a formula to generate random numbers based on a value in a cell. I tried if or formula with nested ifs, but it's ignoring parts of the formula and executed first part only.
The idea is basically this.

If cell A1 is equal or less than 65 or if cell A1 is equal but not more than 75, then randbetween this and that amount, if cell A1 is equal to 75 but not higher than 85, then randbetween this and that number, if A1 is higher than 90, then randbetween.....

Any solutions would be very much appreciated. Thanks.

 

[Hyakkivn]

I don't get what you are trying to say. Can you make it clearer?