Show contents from cell

R

Rubix

The function I am trying to figure out is this:

=IF(ISBLANK(E2),"",IF(N2<2,"Next" <here if N2 is <2 show contents
from cell G1>)))

I want to show contents from cell G1 to the above function, how do I
do this?

Thanks,
Rube
 
P

Pete_UK

I think you want the following:

=IF(ISBLANK(E2),"",IF(N2<2,G1,"not specified"))

You have not specified what you want to happen if N2>=2. Are you sure
you mean G1 and not G2?

Hope this helps.

Pete
 
Top