![]() |
Function Question
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 |
Function Question
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) -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Rubix" wrote in message ... 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 |
Function Question
I've just replied to this on public.excel - please do not multi-post.
Pete |
Function Question
Oops, typo:
Not very what you really want from your post, should be: Not very sure what you really want from your post, -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- |
Function Question
My apologies Pete. Thanks Max!
On 6 Feb 2006 17:05:37 -0800, "Pete" wrote: I've just replied to this on public.excel - please do not multi-post. Pete |
Function Question
You're welcome, Rubix !
-- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Rubix" wrote in message ... My apologies Pete. Thanks Max! On 6 Feb 2006 17:05:37 -0800, "Pete" wrote: I've just replied to this on public.excel - please do not multi-post. Pete |
All times are GMT +1. The time now is 01:19 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com