Show contents from cell

[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

 

[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