Function Question

[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

 

[Max]

Not very what you really want from your post,
but try in say, O2: =IF(E2="","",IF(N2<2,G1,""))

I've assumed that if N2 >=2, nothing: "" is to be returned
(Your post was silent on this)

 

[Pete]

I've just replied to this on public.excel - please do not multi-post.

Pete

 

[Max]

Oops, typo:

Not very what you really want from your post,

should be:

Not very sure what you really want from your post,

---

 

[Rubix]

My apologies Pete. Thanks Max!

 

[Max]

You're welcome, Rubix !

---