help with nesting

mrowe · May 24th, 2002, 06:49 AM

hi,

I'm trying to nest these statements...is it possible...

1) DATEDIF(A1,B1,"d")
and
2) IF(AND(B2>30,B2>=60),"x","")

Thanks
Matt

PDuPre' · May 24th, 2002, 07:34 AM

=IF(AND(B3>30,B3>=60),DATEDIF(A2,B2,"d"),"")
[EDIT] - Tested and works great on '97.

[ This Message was edited by: PDuPre' on 2002-05-24 06:42 ]

Aladin Akyurek · May 24th, 2002, 07:47 AM

Quote:

On 2002-05-24 05:49, mrowe wrote:
hi,

I'm trying to nest these statements...is it possible...

1) DATEDIF(A1,B1,"d")
and
2) IF(AND(B2>30,B2>=60),"x","")

Thanks
Matt

What is the relation between these 2 formulas?

By the way, B2>=60 is not needed in the AND(B2>30,B2>=60) bit of the second formula, because B2>30 already covers what B2>=60 covers.

PDuPre' · May 24th, 2002, 07:55 AM

This formula will only perform the DatedIf statement if the value is >=60. So really the >30 is not needed. No point.

mrowe · May 24th, 2002, 07:56 AM

there are 4 cells it's being entered into.
30,60,90,90+ days
Hence a greater than less than senario.
I'll try my luck with the other one and go from there....
thanks both for your help.
Matt

PDuPre' · May 24th, 2002, 01:25 PM

What "other" one?

Anything worth sharing?

Philip

[ This Message was edited by: PDuPre' on 2002-05-24 16:30 ]

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 24th, 2002, 06:49 AM	#1
mrowe Board Regular Join Date: Feb 2002 Posts: 232	hi, I'm trying to nest these statements...is it possible... 1) DATEDIF(A1,B1,"d") and 2) IF(AND(B2>30,B2>=60),"x","") Thanks Matt

May 24th, 2002, 07:34 AM	#2
PDuPre' Board Regular Join Date: Apr 2002 Location: Trussville, AL Posts: 134	=IF(AND(B3>30,B3>=60),DATEDIF(A2,B2,"d"),"") [EDIT] - Tested and works great on '97. [ This Message was edited by: PDuPre' on 2002-05-24 06:42 ]

May 24th, 2002, 07:55 AM	#4
PDuPre' Board Regular Join Date: Apr 2002 Location: Trussville, AL Posts: 134	This formula will only perform the DatedIf statement if the value is >=60. So really the >30 is not needed. No point.

May 24th, 2002, 07:56 AM	#5
mrowe Board Regular Join Date: Feb 2002 Posts: 232	there are 4 cells it's being entered into. 30,60,90,90+ days Hence a greater than less than senario. I'll try my luck with the other one and go from there.... thanks both for your help. Matt

May 24th, 2002, 01:25 PM	#6
PDuPre' Board Regular Join Date: Apr 2002 Location: Trussville, AL Posts: 134	What "other" one? Anything worth sharing? Philip [ This Message was edited by: PDuPre' on 2002-05-24 16:30 ]