Combine IF and Min statement

[Kelli Webb]

Hi, I've got what appears easy but was not lol

I would just like some help if count between two dates = 0, use 1.00 as the min

thank you,

 

[GraH - Guido]

Maybe simply like so =IF(ISNUMBER($B2),MAX(1,($B2-$A2)),"")

 

[Kelli Webb]

Maybe simply like so =IF(ISNUMBER($B2),MAX(1,($B2-$A2)),"")

Wow - you guys make it look so easy, I hope to be more proficient in the future.

take care & thank you!!
Kelli

 

[Kelli Webb]

Maybe simply like so =IF(ISNUMBER($B2),MAX(1,($B2-$A2)),"")

Hi GraH - Guido,

I would like the formula to be a minimum of 1 if the date opened and closed is the same, but not if the date closed is before the date opened i.e. usually indicates that it is a typo. I've updated the table as an example.

thanks,

 

[GraH - Guido]

Hi Kelli

Would this work? =IF(ISNUMBER($B2),MAX(1*(A2<=B2),($B2-$A2)),"")
If result is 0 then you have a typo.

Custom Format might help: 0,0,[red]"Close Prior to Open".