A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » New Users
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

A zero result



 
 
Thread Tools Display Modes
  #11  
Old August 20th, 2004, 03:07 PM
JulieD
external usenet poster
 
Posts: n/a
Default

glad to assist ...


"Tonya Marshall" wrote in message
...
Thank you, JulieD, that works.
Great newsgroup here.
Tonya

JulieD wrote:

Hi Tonya

a IF function has three elements the test, what happens if it's true &

what
happens if it's false
=IF(test, true, false)

you can also nest IF functions within other IF functions for example
=IF(test,IF(test,true,false),IF(test,true,false))
here another IF is nested within both the true and false elements of the
original IF
(you can nest up to 7 IFs)

so to only show 1 when there's something in column A then nest the IF

inside
another IF, e.g.
=IF(A1="","",IF(DAYS360(A1,V1)=0,1,DAYS360(A1,V1)) )
this means if there's nothing in A1 show nothing
or
=IF(OR(A1="",V1=""),"",IF(DAYS360(A1,V1)=0,1,DAYS3 60(A1,V1)))
this means if there is nothing in A1 or nothing in V1 show nothing

Hope this helps
Cheers
JulieD



"Tonya Marshall" wrote in message
...
Questions, questions. Sorry about the multiple post but questions keep
arising.
I copied the formula down the column and there is a column of results

of
1 all the way down. Is there a way not to have any results until the
formula is actually calculated?
Thanks.
Tonya Marshall

Tonya Marshall wrote:

I am very new to Excel and having to learn everything from a blank

slate.
My friend gave me the following formula to calculate days of stay and

it
works well except I would like to have something in the formula that

if
the result is zero, then make it 1.
=DAYS360(A1,V1)
Thank you.







  #12  
Old August 20th, 2004, 03:07 PM
Tonya Marshall
external usenet poster
 
Posts: n/a
Default

Thanks Bernard. I do have Excel 2002 for Dummies g, the Quick
Reference, and I'm going through it, but it doesn't get very specific
about formulas. Hopefully, I won't have to get too complicated. I'm
making a spreadsheet for about 6 people to use to enter data and I'm
trying to automate it as much as possible to make it as easy as
possible. The others that will be using it know even less than I do
about it, if that's possible.
Tonya

Bernard Liengme wrote:

=IF(A10, IF(DAYS360(A1,V1)=0,1,DAYS360(A1,V1)), " ")
or
=IF(A10, MAX(1,DAYS360(A1,V1), " ")

You cannot learn Excel piecemeal; it is time for a book!

Best wishes



  #13  
Old August 21st, 2004, 08:17 PM
Tonya Marshall
external usenet poster
 
Posts: n/a
Default

Back to the drawing board. I'm trying to keep a running total in column
Y using the data in Column X and have column Y blank until there's
data in Column X. I'm not doing so well. Here's my formula:
(My rows start with Row 3 as I have headings in all the columns)
IF(OR(X3="",Y2=""),"",SUM(X3,Y2))

If it's needed the Dates in Column A and Column V are the ones I use to
get days of stay in column X.

Thank you.
Tonya Marshall

JulieD wrote:
glad to assist ...


"Tonya Marshall" wrote in message
...
Thank you, JulieD, that works.
Great newsgroup here.
Tonya

JulieD wrote:

Hi Tonya

a IF function has three elements the test, what happens if it's true &

what
happens if it's false
=IF(test, true, false)

you can also nest IF functions within other IF functions for example
=IF(test,IF(test,true,false),IF(test,true,false))
here another IF is nested within both the true and false elements of the
original IF
(you can nest up to 7 IFs)

so to only show 1 when there's something in column A then nest the IF

inside
another IF, e.g.
=IF(A1="","",IF(DAYS360(A1,V1)=0,1,DAYS360(A1,V1)) )
this means if there's nothing in A1 show nothing
or
=IF(OR(A1="",V1=""),"",IF(DAYS360(A1,V1)=0,1,DAYS3 60(A1,V1)))
this means if there is nothing in A1 or nothing in V1 show nothing

Hope this helps
Cheers
JulieD



"Tonya Marshall" wrote in message
...
Questions, questions. Sorry about the multiple post but questions keep
arising.
I copied the formula down the column and there is a column of results

of
1 all the way down. Is there a way not to have any results until the
formula is actually calculated?
Thanks.
Tonya Marshall

Tonya Marshall wrote:

I am very new to Excel and having to learn everything from a blank
slate.
My friend gave me the following formula to calculate days of stay and

it
works well except I would like to have something in the formula that

if
the result is zero, then make it 1.
=DAYS360(A1,V1)
Thank you.








  #14  
Old August 21st, 2004, 08:52 PM
RagDyeR
external usenet poster
 
Posts: n/a
Default

One way:

Enter this in Y3, and drag down to copy:

=IF(X30,SUM($X$3:X3),"")

--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


"Tonya Marshall" wrote in message
...
Back to the drawing board. I'm trying to keep a running total in column
Y using the data in Column X and have column Y blank until there's
data in Column X. I'm not doing so well. Here's my formula:
(My rows start with Row 3 as I have headings in all the columns)
IF(OR(X3="",Y2=""),"",SUM(X3,Y2))

If it's needed the Dates in Column A and Column V are the ones I use to
get days of stay in column X.

Thank you.
Tonya Marshall

JulieD wrote:
glad to assist ...


"Tonya Marshall" wrote in message
...
Thank you, JulieD, that works.
Great newsgroup here.
Tonya

JulieD wrote:

Hi Tonya

a IF function has three elements the test, what happens if it's true &

what
happens if it's false
=IF(test, true, false)

you can also nest IF functions within other IF functions for example
=IF(test,IF(test,true,false),IF(test,true,false))
here another IF is nested within both the true and false elements of

the
original IF
(you can nest up to 7 IFs)

so to only show 1 when there's something in column A then nest the IF

inside
another IF, e.g.
=IF(A1="","",IF(DAYS360(A1,V1)=0,1,DAYS360(A1,V1)) )
this means if there's nothing in A1 show nothing
or
=IF(OR(A1="",V1=""),"",IF(DAYS360(A1,V1)=0,1,DAYS3 60(A1,V1)))
this means if there is nothing in A1 or nothing in V1 show nothing

Hope this helps
Cheers
JulieD



"Tonya Marshall" wrote in message
...
Questions, questions. Sorry about the multiple post but questions keep
arising.
I copied the formula down the column and there is a column of results

of
1 all the way down. Is there a way not to have any results until the
formula is actually calculated?
Thanks.
Tonya Marshall

Tonya Marshall wrote:

I am very new to Excel and having to learn everything from a blank
slate.
My friend gave me the following formula to calculate days of stay

and
it
works well except I would like to have something in the formula that

if
the result is zero, then make it 1.
=DAYS360(A1,V1)
Thank you.









  #15  
Old August 21st, 2004, 10:23 PM
Tonya Marshall
external usenet poster
 
Posts: n/a
Default

It works, but when I copy it down it shows the last total all the way
down. I want column Y empty if there's nothing in Column X

RagDyeR wrote:
One way:

Enter this in Y3, and drag down to copy:

=IF(X30,SUM($X$3:X3),"")


  #16  
Old August 21st, 2004, 10:57 PM
RagDyeR
external usenet poster
 
Posts: n/a
Default

=SUM($X$3:X3)
will copy the last total all the way down in my sheet.

=IF(X30,SUM($X$3:X3),"")
Will leave column Y *empty* when column X is empty, or, if column X displays
a zero from your "=DAYS360(A3,V3)" formula.

Are you sure that you copied it exactly?
What exactly do you have in column X?
--

Regards,

RD
--------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
--------------------------------------------------------------------

"Tonya Marshall" wrote in message
...
It works, but when I copy it down it shows the last total all the way
down. I want column Y empty if there's nothing in Column X

RagDyeR wrote:
One way:

Enter this in Y3, and drag down to copy:

=IF(X30,SUM($X$3:X3),"")



  #17  
Old August 21st, 2004, 11:06 PM
Tonya Marshall
external usenet poster
 
Posts: n/a
Default

RagDyeR wrote:

=SUM($X$3:X3)
will copy the last total all the way down in my sheet.

=IF(X30,SUM($X$3:X3),"")
Will leave column Y *empty* when column X is empty, or, if column X displays
a zero from your "=DAYS360(A3,V3)" formula.

Are you sure that you copied it exactly?
What exactly do you have in column X?


I copied and pasted your formula into Y3

This is the formula I have in Column V. It's set up so that if A and V
are the same date it returns a 1. The column below the last figure is blank.
=IF(OR(A3="",V3=""),"",IF(DAYS360(A3,V3)=0,1,DAYS3 60(A3,V3)))

--
Tonya Marshall
tonz AT harborside DOT com

  #18  
Old August 22nd, 2004, 12:13 AM
Tonya Marshall
external usenet poster
 
Posts: n/a
Default

Tonya Marshall wrote:

RagDyeR wrote:

=SUM($X$3:X3)
will copy the last total all the way down in my sheet.

=IF(X30,SUM($X$3:X3),"")
Will leave column Y *empty* when column X is empty, or, if column X displays
a zero from your "=DAYS360(A3,V3)" formula.

Are you sure that you copied it exactly?
What exactly do you have in column X?


I copied and pasted your formula into Y3



That should be: "Formula in Column X," below.

This is the formula I have in Column V. It's set up so that if A and V
are the same date it returns a 1. The column below the last figure is blank.
=IF(OR(A3="",V3=""),"",IF(DAYS360(A3,V3)=0,1,DAYS3 60(A3,V3)))



--
Tonya Marshall
tonz AT harborside DOT com

  #19  
Old August 22nd, 2004, 04:40 AM
Ragdyer
external usenet poster
 
Posts: n/a
Default

The formula you're using in column X should make this slight revision work
in column Y:

=IF(X3"",SUM($X$3:X3),"")
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"Tonya Marshall" wrote in message
...
Tonya Marshall wrote:

RagDyeR wrote:

=SUM($X$3:X3)
will copy the last total all the way down in my sheet.

=IF(X30,SUM($X$3:X3),"")
Will leave column Y *empty* when column X is empty, or, if column X

displays
a zero from your "=DAYS360(A3,V3)" formula.

Are you sure that you copied it exactly?
What exactly do you have in column X?


I copied and pasted your formula into Y3



That should be: "Formula in Column X," below.

This is the formula I have in Column V. It's set up so that if A and V
are the same date it returns a 1. The column below the last figure is

blank.
=IF(OR(A3="",V3=""),"",IF(DAYS360(A3,V3)=0,1,DAYS3 60(A3,V3)))



--
Tonya Marshall
tonz AT harborside DOT com


  #20  
Old August 22nd, 2004, 05:10 AM
Tonya Marshall
external usenet poster
 
Posts: n/a
Default



Ragdyer wrote:
The formula you're using in column X should make this slight revision work
in column Y:

=IF(X3"",SUM($X$3:X3),"")


Thank you, RD, so much. It's perfect.
Tonya

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Rounding a result Johnny Lunchbucket General Discussion 1 July 27th, 2004 05:57 PM
Can I make a formula that has the result of "0" remain empty? DangerMouse114 Worksheet Functions 2 May 12th, 2004 06:00 AM
using & to concatenate result is yuck Jamie Worksheet Functions 3 April 9th, 2004 06:29 PM
Readding Numerical value to ext Hoang Han Worksheet Functions 2 December 4th, 2003 06:37 PM


All times are GMT +1. The time now is 09:38 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.