View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
soconfused soconfused is offline
external usenet poster
 
Posts: 93
Default 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"