Question

if you copy formula '=A1*$C$2 given in cell A2 to cell B2, what will the formula be? {a, b, c or d}
a) =A1*$C$2
b) =B1*$C$2
c) =A1*$D$2
d) =B1*$D$2

Answer 1

You will find a variety of IF formula examples for text, ... the formula tells Excel to return "No" if a cell in column C ... If A1 contains an empty string, the formula returns 0.