79157231

Date: 2024-11-04 23:07:02
Score: 1.5
Natty:
Report link

You can also use IFERROR function. This function let's you return a desired value with the formula results in an #N/A error.

In your example try: =IFERROR(A1*B1,B1)

So if A1 is a value then it will calculate "A1*B1". If A1 is #N/A this calculation will error trying to multiply, so the formula will just result in "B1".

Reasons:
  • No code block (0.5):
  • Low reputation (1):
Posted by: Steven Lau