Which of the following formula is used to make the recording decision in B20? A) =IFB190,"In-house","Studio") B) =IFB19

Question

Which of the following formula is used to make the recording decision in B20? A) =IFB19>0,"In-house","Studio") B) =IFB19<=0,"Studio","In-house") C) =SUMB19<=0,"Studio") D) =IFB19>0,"Studio","In-house")

Quizplus · Accepted Answer

The correct formula is B) =IFB19<=0,"Studio","In-house") because it checks if the value in cell B19 is less than or equal to 0, and if so, it returns "Studio"; otherwise, it returns "In-house". This logic is typically used to make decisions based on a condition, which is what the question implies.

Which of the Following Formula Is Used to Make the Recording