How can I get rid of the FALSE..?

[Mykro]

{=IF(LEN(M91),IF($D$6:$J$64="TEXT",SUM($D$5:$J$63),""))}

If I don't have any data in the cells I get a
FALSE.. It works fine when data is entered.. I'm missing something...What??

 

[Yogi Anand]

Hi Mykro:

I don't know the background on your formula, or its purpose, so I am going by some assumptions -- change your formula from

'=IF(LEN(M9),IF($D$6:$J$14="TEXT",SUM($D$5:$J$13),""))

to

'=IF(LEN(M9),IF($D$6:$J$14="TEXT",SUM($D$5:$J$13),""),"")

See if this does what you want -- otherwise explain a little further and let us take it from there.

 

[Mykro]

Thanks Yogi.. It Worked !!

Explain the double quotes?? I get confused with the syntax..

Thanks Again

 

[Yogi Anand]

Hi Mike:

Let us disect the modified formula:

'=IF(LEN(M9),IF($D$6:$J$14="TEXT",SUM($D$5:$J$13),""),"")

This is a nested IF formula -- the syntax being ...

=<font color=red>IF(condition,<font color=blue>{result_if-true}IF(condition,result_if_true,result_if_false),<font color=green>result_if_false)<font><font><font color=black>

"" says give me a blank (instead of a value, a zero, ... etc.


_________________
Regards!
Yogi Anand
This message was edited by Yogi Anand on 2002-12-20 21:50
This message was edited by Yogi Anand on 2002-12-20 22:35

 

[Mykro]

Thanks Yogi..
I've got another one for you...
On (sheet1!M90) I have text That needs to go
across multiple worksheets.. I understand this =sum(first:last!M90)
Now I'm using Text.. What would be the correct function for text.??

Thanks Yogi

 

[Yogi Anand]

Hi Mike:

if the entry in cell Sheet1!M90 needs to go in cell M90 of other sheets as well, then select all the sheets of interest(by holding the SHIFT key and clicking on the TAB of the respective sheets), then in cell M90 of sheet1, or for that matter, cell M90 of any of the selected sheets make the entry -- this entry will then be made in cell M90 of all the selected sheets.

If the entry in sheet1!M90 goes in some other cell of another sheet, then you have to use the linking formula. Let us say you want to link entry in Seet1!M90 to sheet3!J23, then go to Sheet3!J23 and key-i =Sheet1!M90.

So, this way, you can choose to embed the entries, link the entries, or a combination of embeding and linking.

I hope this helps.

_________________
Regards!
Yogi Anand
This message was edited by Yogi Anand on 2002-12-20 22:44

 

[Mykro]

But I would have to continue to do this Week after week.. Isn't there one formula to use
regardless of how many worksheets that get added each week to the work book??
Thanks

 

[Yogi Anand]

Hi Mike:

I don't think the formula based approach I suggested will work on sheets you add later on.

 

[Aladin Akyurek]

On 2002-12-20 21:34, Mykro wrote:
Thanks Yogi.. It Worked !!

Explain the double quotes?? I get confused with the syntax..

Thanks Again

Well, I for one, does not understand why, array-entered or not,

=IF(LEN(M9),IF($D$6:$J$14="TEXT",SUM($D$5:$J$13),""),"")

(or the original) would work?

 

[Mykro]

Aladin,
That formulas works fine... Thanks Yogi.. I was talking about something else.. I need to span text across multiple worksheets.

This formulas works here.. This I am using and it works fine..
=SUM(first:Last!A19) for summing numbers across worksheets.

In this case I have to copy Names from one worksheet to another EX: (Sheet1!M90 "John Doe") to (Sheet2!B20 "John Doe) How can I to it Using the Sheets First:Last! ??

Thanks
This message was edited by Mykro on 2002-12-21 07:12