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
  #1  
Old August 20th, 2004, 01:34 PM
Tonya Marshall
external usenet poster
 
Posts: n/a
Default 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  
Old August 20th, 2004, 01:43 PM
CLR
external usenet poster
 
Posts: n/a
Default

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  
Old August 20th, 2004, 01:57 PM
Tonya Marshall
external usenet poster
 
Posts: n/a
Default

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  
Old August 20th, 2004, 02:03 PM
Tonya Marshall
external usenet poster
 
Posts: n/a
Default

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  
Old August 20th, 2004, 02:25 PM
Lady Layla
external usenet poster
 
Posts: n/a
Default

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  
Old August 20th, 2004, 02:27 PM
Tonya Marshall
external usenet poster
 
Posts: n/a
Default

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  
Old August 20th, 2004, 02:36 PM
Tonya Marshall
external usenet poster
 
Posts: n/a
Default

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  
Old August 20th, 2004, 02:46 PM
JulieD
external usenet poster
 
Posts: n/a
Default

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  
Old August 20th, 2004, 02:52 PM
Bernard Liengme
external usenet poster
 
Posts: n/a
Default

=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  
Old August 20th, 2004, 03:04 PM
Tonya Marshall
external usenet poster
 
Posts: n/a
Default

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

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 10:31 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.