Need help creating the Nested IF formula

In Row 1, create a header row with the following labels in bold font: e Column A: Vendor Name e Column B: Jet Fuel Price e Column C: Avgas Price In Column A, Rows 2 through 6, list the following vendors in non-bold font: Yellow Plains Fuel Okie Stokie Fuel Best Ever Fuel Smith Bros Fuel Wild West Fuel In Columns B and C, Rows 2 through 6, enter imaginary pricing values for all vendors and both types of fuel, keeping the range of values between $5.00 and $10.00 for each type of fuel. The numerical values for each type of fuel must be different. Format the cells in Columns B and C, Rows 2 through 6 as Currency with TWO decimal places. P [P SV I SNV | T AV Y A T==T- 0. I STV o B V.Y I V2N