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?
- A.
=IF(CELL("contents",A1)="v",A1*2,0)
- B.
=IF(CELL("format",A1)="v",A1*2,0)
- C.
=IF(CELL("type",A1)="v",A1*2,0)
- D.
=IF(CELL("address",A1)="v",A1*2,0)
- E.
=IF(CELL("col",A1)="v",A1*2,0)
Attempted by 18 students.
Sign up free to check your answer
Sign up freeLoading lesson…

