Welcome Guest.


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 March 25, 2022

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

1 Answers

  1. +4Votes  

    formula 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 |