ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Function Question (https://www.excelbanter.com/excel-worksheet-functions/69947-function-question.html)

Rubix

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

Max

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




Pete

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

Pete


Max

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
---



Rubix

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



Max

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