Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
some complicated if statements/formulas
Hi,
Im creating an excel sheet to track my accounts and I wonder if someone could give me some advice on a couple of if statements I cant figure out? 1. I want a the first column in the sheet to look at the date in second column and thendisplay which quarter the work was completed in, so the statement would run something like this: if the date in the adjacent cell is between January and march, display Q1. 2. I need to track keep a running track of profits. Subtracting current expenditure from profit is easy, but I also have to factor in a weekly national insurance payment. I want to tell excel to check the weekly rate, then tell it to check the current date, and each week add that weeks payment to total insurance payments to date. This total can then be subtracted from the total profit along with other expenditure. If anyone can help me with either formula Id be very grateful. Thanks Karl |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
some complicated if statements/formulas
On Jul 28, 3:52 pm, Karl wrote:
1. I want a the first column in the sheet to look at the date in second column and thendisplay which quarter the work was completed in, so the statement would run something like this: "if the date in the adjacent cell is between January and march, display 'Q1'". One way: ="Q" & int((month(A1)-1)/3)+1 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
some complicated if statements/formulas
"Karl" wrote in message
... Hi, I'm creating an excel sheet to track my accounts and I wonder if someone could give me some advice on a couple of if statements I can't figure out? 1. I want a the first column in the sheet to look at the date in second column and thendisplay which quarter the work was completed in, so the statement would run something like this: "if the date in the adjacent cell is between January and march, display 'Q1'". 2. I need to track keep a running track of profits. Subtracting current expenditure from profit is easy, but I also have to factor in a weekly national insurance payment. I want to tell excel to check the weekly rate, then tell it to check the current date, and each week add that week's payment to total insurance payments to date. This total can then be subtracted from the total profit along with other expenditure. If anyone can help me with either formula I'd be very grateful. Thanks Karl The following formula will deal with question 1- =IF(MONTH(B1)<4,"Q1",IF(MONTH(B1)<7,"Q2",IF(MONTH( B1)<10,"Q3","Q4"))) Regards. Bill Ridgeway Computer Solutions |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Complicated insert / drag formulas | Excel Discussion (Misc queries) | |||
Complicated formulas | Excel Worksheet Functions | |||
Answer's a little more complicated than regular formulas, but what do I need to do? | Excel Discussion (Misc queries) | |||
Formulas are getting too complicated | Excel Worksheet Functions | |||
Complicated Formulas | Excel Worksheet Functions |