Questions & Answers for: Microsoft Excel maths

Asking Excel to insert a drop down list based on previously entered text Example, Say in Cell A1 "Breakfast" is typed in. In A2 I'd like a drop down menu to appear, i.e. with cereal, toast, yoghurt, ...

Need to Add Dates in Excel I have a fixed assets excel sheet that shows the date an item was purchased. Example: 12/21/2006. I need to show a date for estimated remaining life of this item. Since most

what is the formula to convert the time of 4:15 to 4.25 hours? I'm trying to add up the number of hours I do child care. If you calculate 0.1hr as 6mins, you can get what you ask for.. This is just ...

how to calculate a permutation problem in a lottery of 1 - 45 digits I assume you are looking for the number of combinations of 1 - 45 where the first number is one of the 45, the second number is one

I want to write an Excel IF statement using only mathematical operators (in another application). The Excel formulation is: ...