when you create a Today() formula, can you then use conditional formatting to highlight another date. i.e when it gets to 6 months after a last appointment.
...time/date functions like TODAY () an? If you keep your computers clock set correctly I know that you can use functions like TODAY () and NOW () to get the current time and date from the system clock, but once you get this valuable information how can you keep it? What I mean is, if you have...
=VLOOKUP(Nights,PricePerNight,3)-VLOOKUP(Nights,PricePerNight,3)*IF(F10="yes",Constants!B15,0)-VLOOKUP(Nights,PricePerNight,3)*VLOOKUP(NumberOfCats,CatDiscount,2)
this is my formula and it works however not with the result i was wanting.
=VLOOKUP(Nights,PricePerNight,3) - this is the origional...
(mm/dd/yyyy)? I've successfully exported a Excel 2007 file to a XML file using Excels built in XML exporter. My problem is that the dates and percentages change when exported to the XML file. The dates are converted to serial dates and the percentages are converted to decimals from 0.0-1.0
My...
I have a set of 10 x-values that will be used in making the bell curve. I want to make a bell curve graph that is actually a curve (ie. doesn't come to a point). All help is appreciated. Thank you!
i can figure out why i cant see the right trend line curve on this graph, it looks as a solid line
it shows like this
http://i56.tinypic.com/1192ip3.jpg
How do i solve this problem?
I have the atomic numbers of elements that is suppose to be on the left side of my graph. While the bp (boiling point) needs to be at the bottom. The graph needs to have the line zig zagging from the bottom to the top from its boiling points. So does anyone know how to make the line graph go up...
I am making a scatter plot in Excel, is there any way to have the points line up to the values on the x-axis? Right now there are fixed values on the x-axis, but the points are placed in between. Is there a way to just have the actual value line up with the x-axis, and just have it "estimate"...
I am making a scatter plot in Excel, is there any way to have the points line up to the values on the x-axis? Right now there are fixed values on the x-axis, but the points are placed in between. Is there a way to just have the actual value line up with the x-axis, and just have it "estimate"...
If in cell A1 I write the month with the year, how can I get all the dates of that month in a list starting A2?
Thanks in advance,
Have a great day,
Aarzu
so i know, it's illegal and all, but if i don't download them to my laptop my grades are going to be illegal, so pleaaseee help me :)
does anyone know where i could download them? cause i've been looking and it's like not working for some strange abnormal reason
thanks
xx
owns a truck and he has this guy working? for him, so we get pay from this other person, but lets say we get a check thats 4000 dollars a week, but this guy our boss keeps 12% of those 4000 dollars how can i get a fomula for that and get the result to be $3520? Please HELP!!!
So that B1 becomes A2 etc. Sorry if this question has just been asked by me previously. It didn't come up so I am trying it again. Thanks for any help received.
Hi, I'm trying to make a table of contents, and I have sheet numbers which vary
I can make page numbers in the footer, so then for example I want the cell A4 to display the number in the footer
I spent a lot of time creating a file in excel 2007. I saved and reopened the program, everything worked fine.
Now when I try to open it, I get the message " File extention is different from the file format ".
I have spent too much time on this to let it go. Any suggestion is greatly...
Hi, I need to assign a number to letters in excel....how can i do this...
if i give the name it should match with the respective number and give me the sum of those characters. (Eg.: chand=16) Could you explain to me if there is any code for this?
Thanks
Chandru
I am an excel newbie. I have a very simple table that calculates the VAT for me. Is there an easy way to 'fix' this formula to a whole column so that if i add new rows the formula still applies without me having to copy and paste the formula again?
I want to create a formula that varies dependent upon what is entered in a drop down box. The drop down will include 2 options, dollar or percentage (d1 below). If i select percentage i want the formula to take the entered value in my example (d3 below shown as $500 in my example) and muliply...
I want to create a formula that varies dependent upon what is entered in a drop down box. The drop down will include 2 options, dollar or percentage (d1 below). If i select percentage i want the formula to take the entered value in my example (d3 below shown as $500 in my example) and muliply...