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"

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"

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"

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"

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"
|
|
|

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"