1Answers

# I have three cells of A1, B1, and C1. I want to use data when A1 is available, A2 displays A1 data.

Asked by: Jason Murphy 63 views Hardware

I have three cells of A1, B1, C1, I want to display A1 data when A1 is data, when B1 is data, when the B1 is data, when C1 is data, A2 Displays C1 data

+4

Votesformula is as follows:

= if (C1 <> “, C1, IF (B1 <>“, B1, IF (A1 <> “, A1)))

means which is preferred, which result is in front of the formula.

Janice- March 25, 2022 |