Trying to write an IF statement to return one value if the cell is empty and
another if not. For example, if the cell is empty, return the value above,
if not empty, return the value itself.

=if(ISBLANK(A2),A1,A2)

"srosebed" wrote:

> Trying to write an IF statement to return one value if the cell is empty and
> another if not. For example, if the cell is empty, return the value above,
> if not empty, return the value itself.

=IF(C2="",C1,C2)

if I understand you correctly.
___________________________________________________________________________

"srosebed" <(E-Mail Removed)> wrote in message
news:22B0AF9F-C475-4C60-9B18-(E-Mail Removed)...
> Trying to write an IF statement to return one value if the cell is empty
> and
> another if not. For example, if the cell is empty, return the value
> above,
> if not empty, return the value itself.

It depends, would the cell be the next cell above?

=IF(A5="",A4,A5)


--
Regards,

Peo Sjoblom


"srosebed" <(E-Mail Removed)> wrote in message
news:22B0AF9F-C475-4C60-9B18-(E-Mail Removed)...
> Trying to write an IF statement to return one value if the cell is empty
> and
> another if not. For example, if the cell is empty, return the value
> above,
> if not empty, return the value itself.

That's it!! Thanks a million.

"Toppers" wrote:

> =if(ISBLANK(A2),A1,A2)
>
> "srosebed" wrote:
>
> > Trying to write an IF statement to return one value if the cell is empty and
> > another if not. For example, if the cell is empty, return the value above,
> > if not empty, return the value itself.

Thanks!

"Peo Sjoblom" wrote:

> It depends, would the cell be the next cell above?
>
> =IF(A5="",A4,A5)
>
>
> --
> Regards,
>
> Peo Sjoblom
>
>
> "srosebed" <(E-Mail Removed)> wrote in message
> news:22B0AF9F-C475-4C60-9B18-(E-Mail Removed)...
> > Trying to write an IF statement to return one value if the cell is empty
> > and
> > another if not. For example, if the cell is empty, return the value
> > above,
> > if not empty, return the value itself.
>
>
>

Thanks! for another approach.

"Vasant Nanavati" wrote:

> =IF(C2="",C1,C2)
>
> if I understand you correctly.
> ___________________________________________________________________________
>
> "srosebed" <(E-Mail Removed)> wrote in message
> news:22B0AF9F-C475-4C60-9B18-(E-Mail Removed)...
> > Trying to write an IF statement to return one value if the cell is empty
> > and
> > another if not. For example, if the cell is empty, return the value
> > above,
> > if not empty, return the value itself.
>
>
>

"srosebed" wrote:

> Trying to write an IF statement to return one value if the cell is empty and
> another if not. For example, if the cell is empty, return the value above,
> if not empty, return the value itself.

"Vasant Nanavati" wrote:

> =IF(C2="",C1,C2)
>
> if I understand you correctly.
> ___________________________________________________________________________
>
> "srosebed" <(E-Mail Removed)> wrote in message
> news:22B0AF9F-C475-4C60-9B18-(E-Mail Removed)...
> > Trying to write an IF statement to return one value if the cell is empty
> > and
> > another if not. For example, if the cell is empty, return the value
> > above,
> > if not empty, return the value itself.
>
>
>

"srosebed" wrote:

> That's it!! Thanks a million.
>
> "Toppers" wrote:
>
> > =if(ISBLANK(A2),A1,A2)
> >
> > "srosebed" wrote:
> >
> > > Trying to write an IF statement to return one value if the cell is empty and
> > > another if not. For example, if the cell is empty, return the value above,
> > > if not empty, return the value itself.