D
Diane
I am trying to write a compound if statement and put the answer in a "date
bucket"
bucket"
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
N
Niek Otten
What is your question?
--
Kind regards,
Niek Otten
Microsoft MVP - Excel
|I am trying to write a compound if statement and put the answer in a "date
| bucket"
--
Kind regards,
Niek Otten
Microsoft MVP - Excel
|I am trying to write a compound if statement and put the answer in a "date
| bucket"
S
soconfused
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
27, AND THE NUMBER 1 IS LESS THAN 30, MULTIPLY 5 TIMES 25 AND PUT IT IN CELL
Z10
M
Mike H
what do you want to happen if the number 1 is greater than 30?
N
Niek Otten
I think Chuck answered your question in the meantime.
--
Kind regards,
Niek Otten
Microsoft MVP - Excel
|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
| >
| > |I am trying to write a compound if statement and put the answer in a "date
| > | bucket"
| >
| >
| >
--
Kind regards,
Niek Otten
Microsoft MVP - Excel
|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
| >
| > |I am trying to write a compound if statement and put the answer in a "date
| > | bucket"
| >
| >
| >
S
soconfused
I want it to return a blank.
--
DMM
--
DMM
Mike H said:what do you want to happen if the number 1 is greater than 30?