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. |
|
|
Thread Tools | Display Modes |
#11
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
=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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 | |
|
|
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 05:37 PM |