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 |
#1
|
|||
|
|||
A zero result
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. |
#2
|
|||
|
|||
Hi Tonya..........
Wrap your formula in an IF statement, like =IF(DAYS360(A1,V1)=0,1,DAYS360(A1,V1)) Vaya con Dios, Chuck, CABGx3 "Tonya Marshall" wrote in message ... 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. |
#3
|
|||
|
|||
TADA!! It works!
Thank you so much, Chuck That was a very fast reply. Wow Tonya CLR wrote: Hi Tonya.......... Wrap your formula in an IF statement, like =IF(DAYS360(A1,V1)=0,1,DAYS360(A1,V1)) Vaya con Dios, Chuck, CABGx3 "Tonya Marshall" wrote in message ... 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. |
#4
|
|||
|
|||
I think I should have asked a bit more about the formula.
So adding =IF and then parenthesizing the formula, the =0,1, means then zero=1? I'm curious as to how the formula would read out in verbal language. Thanks. The more I can learn about what I'm doing, hopefully the better I will be able to make formulas. Thanks, Tonya Marshall CLR wrote: Hi Tonya.......... Wrap your formula in an IF statement, like =IF(DAYS360(A1,V1)=0,1,DAYS360(A1,V1)) Vaya con Dios, Chuck, CABGx3 "Tonya Marshall" wrote in message ... 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. |
#5
|
|||
|
|||
If the result of my formula = 0, set the answer to 1, if the result is not = 0,
show the answer of the formula "Tonya Marshall" wrote in message ... : I think I should have asked a bit more about the formula. : So adding =IF and then parenthesizing the formula, the =0,1, means then : zero=1? : I'm curious as to how the formula would read out in verbal language. : Thanks. The more I can learn about what I'm doing, hopefully the better : I will be able to make formulas. : Thanks, : Tonya Marshall : : CLR wrote: : : Hi Tonya.......... : : Wrap your formula in an IF statement, like : : =IF(DAYS360(A1,V1)=0,1,DAYS360(A1,V1)) : : Vaya con Dios, : Chuck, CABGx3 : : : : : "Tonya Marshall" wrote in message : ... : 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. : : : : |
#6
|
|||
|
|||
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. |
#7
|
|||
|
|||
Ah, thank you Lady.
Tonya Lady Layla wrote: If the result of my formula = 0, set the answer to 1, if the result is not = 0, show the answer of the formula "Tonya Marshall" wrote in message ... : I think I should have asked a bit more about the formula. : So adding =IF and then parenthesizing the formula, the =0,1, means then : zero=1? : I'm curious as to how the formula would read out in verbal language. : Thanks. The more I can learn about what I'm doing, hopefully the better : I will be able to make formulas. : Thanks, : Tonya Marshall : : CLR wrote: : : Hi Tonya.......... : : Wrap your formula in an IF statement, like : : =IF(DAYS360(A1,V1)=0,1,DAYS360(A1,V1)) : : Vaya con Dios, : Chuck, CABGx3 : : : : : "Tonya Marshall" wrote in message : ... : 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. : : : : |
#8
|
|||
|
|||
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. |
#9
|
|||
|
|||
=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 -- Bernard Liengme www.stfx.ca/people/bliengme remove CAPS in e-mail address "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. |
#10
|
|||
|
|||
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. |
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 06:37 PM |