| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I write a compound if statement?
I am trying to write a compound if statement and put the answer in a "date
bucket" |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I write a compound if statement?
What is your question?
-- Kind regards, Niek Otten Microsoft MVP - Excel "Diane" wrote in message ... |I am trying to write a compound if statement and put the answer in a "date | bucket" |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I write a compound if statement?
I am trying to write a statement to say IF THE DATE 04/28/06 IS GREATER THAN
27, AND THE NUMBER 1 IS LESS THAN 30, MULTIPLY 5 TIMES 25 AND PUT IT IN CELL Z10 -- DMM "Niek Otten" wrote: What is your question? -- Kind regards, Niek Otten Microsoft MVP - Excel "Diane" wrote in message ... |I am trying to write a compound if statement and put the answer in a "date | bucket" |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I write a compound if statement?
what do you want to happen if the number 1 is greater than 30?
"soconfused" wrote: I am trying to write a statement to say IF THE DATE 04/28/06 IS GREATER THAN 27, AND THE NUMBER 1 IS LESS THAN 30, MULTIPLY 5 TIMES 25 AND PUT IT IN CELL Z10 -- DMM "Niek Otten" wrote: What is your question? -- Kind regards, Niek Otten Microsoft MVP - Excel "Diane" wrote in message ... |I am trying to write a compound if statement and put the answer in a "date | bucket" |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I write a compound if statement?
I want it to return a blank.
-- DMM "Mike H" wrote: what do you want to happen if the number 1 is greater than 30? "soconfused" wrote: I am trying to write a statement to say IF THE DATE 04/28/06 IS GREATER THAN 27, AND THE NUMBER 1 IS LESS THAN 30, MULTIPLY 5 TIMES 25 AND PUT IT IN CELL Z10 -- DMM "Niek Otten" wrote: What is your question? -- Kind regards, Niek Otten Microsoft MVP - Excel "Diane" wrote in message ... |I am trying to write a compound if statement and put the answer in a "date | bucket" |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I write a compound if statement?
I think Chuck answered your question in the meantime.
-- Kind regards, Niek Otten Microsoft MVP - Excel "soconfused" wrote in message ... |I am trying to write a statement to say IF THE DATE 04/28/06 IS GREATER THAN | 27, AND THE NUMBER 1 IS LESS THAN 30, MULTIPLY 5 TIMES 25 AND PUT IT IN CELL | Z10 | -- | DMM | | | "Niek Otten" wrote: | | What is your question? | | -- | Kind regards, | | Niek Otten | Microsoft MVP - Excel | | "Diane" wrote in message ... | |I am trying to write a compound if statement and put the answer in a "date | | bucket" | | | |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I write a comlicated conditional statement? | Excel Worksheet Functions | |||
| How do you write an if statement that replaces #DIV/0! with 0 | Excel Discussion (Misc queries) | |||
| How do I write an 'if exist" statement | Excel Worksheet Functions | |||
| how do I write the date in an if statement | Excel Worksheet Functions | |||
| Problem with compound IF statement | Excel Worksheet Functions | |||
Hybrid Mode
