You are responsible for valuing the inventory of a crude oil depot based on daily closing prices, and you have created a spreadsheet to help you. The cells in column A tell the ownership status of individual grades of oil $($Holding or Not Holding$),$ column B reports the closing price, and column C issues instructions based on the closing price $($Bid$,$ Offer, or Do Nothing$).$ The rules for taking action are as follows:

If the closing price is $$$$75$ and we own the oil, we will Offer it for sale.

If the closing price is $$$$55$ and we do not own the oil, we will Bid for its acquisition.

Otherwise, we will Do Nothing.

What formula should you enter in cell $C2$ to conduct this analysis?

IF$($A$2=$"Holding",B$2>=75),$"Offer", IF$(($A$2=$"Not Holding",B"Acquire","Do Nothing"$))$

IF$($AND$($A$2=$"Holding",B$2>=75),$"Offer",IF$($AND$($A$2=$"Not Holding",B"Offer","Do Nothing"$))$

IF$($AND$($A$2=$"Not Holding",B$2>=75),$"Offer",IF$($AND$($A$2="$ Holding",B"Bid","Do Nothing"$))$

IF$($AND$($A$2=$"Holding",B$2>=75),$"Offer",IF$($AND$($A$2=$"Not Holding",B"Acquire", $"$Do Nothing"$))$