View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
PCLIVE PCLIVE is offline
external usenet poster
 
Posts: 1,311
Default Problem with IF Statement

Maybe this:

=IF(AND(J111,J1<=I1),J1-D1,"FalseCondition")

You'll need to specify the FalseCondition. If you want it to remain blank,
then:

=IF(AND(J111,J1<=I1),J1-D1,"")

HTH,
Paul


--

"M Peddle" <M wrote in message
...
I am not even sure if this is possible or not.

If J is more than 11, but not more than I, I need to know what is J minus
D