Which of the following Excel formulas performs a calculation only when cell A1…

PYQ IBPS SO CRP SPL-XIII (2023)

Which of the following Excel formulas performs a calculation only when cell A1 contains a value-type entry, and otherwise returns 0?

  1. A.

    =IF(CELL("contents",A1)="v",A1*2,0)

  2. B.

    =IF(CELL("format",A1)="v",A1*2,0)

  3. C.

    =IF(CELL("type",A1)="v",A1*2,0)

  4. D.

    =IF(CELL("address",A1)="v",A1*2,0)

  5. E.

    =IF(CELL("col",A1)="v",A1*2,0)

Attempted by 18 students.

Sign up free to check your answer

Sign up free

Explore the full course: Sbi Po Mains

Loading lesson…