The Method column has 2 possible values: Flatbed or Van. The Price column has decimal values.

I want to run the formula: =20+80*RAND() to generate random decimal numbers into the Price column (Column B) based on if the value in Method (Column A) is equal to the text/value of "Flatbed".

I have tried using the IF function of IF( =A2="Flatbed",=B2=20+80*RAND(), 0 ) but that didn't work.

What is the method or formula that will run the =20+80*RAND() function to populate the Price column if the Method column = Flatbed ?

Thanks.