Formula help needed
Excel 97.
Column/Row B2 = text value Column/Row O2 = Date value I need a formula to evaluate as follows: If B2 & O2 contain no value return "", if B2 contains a value & O2 is null return 0 (zero), otherwise calculate today()-O2. I have been trying many variations of formulas to return the above results without any success. Can anyone advise on the correct formula to enter? TIA Jan |
Formula help needed
Hi!
O2 is null Null means different things to different people! Does null mean an empty cell (no formulas, nothing), a number 0, or a blank cell (formula blank: "") ? Try this: =IF(COUNTA(B2,O2)=0,"",IF(AND(B2<"",O2=""),0,TODA Y()-O2)) Biff "Jan" wrote in message ... Excel 97. Column/Row B2 = text value Column/Row O2 = Date value I need a formula to evaluate as follows: If B2 & O2 contain no value return "", if B2 contains a value & O2 is null return 0 (zero), otherwise calculate today()-O2. I have been trying many variations of formulas to return the above results without any success. Can anyone advise on the correct formula to enter? TIA Jan |
Formula help needed
Hi Biff,
Thank you...that appears to work as needed. Jan "Jan" wrote: Excel 97. Column/Row B2 = text value Column/Row O2 = Date value I need a formula to evaluate as follows: If B2 & O2 contain no value return "", if B2 contains a value & O2 is null return 0 (zero), otherwise calculate today()-O2. I have been trying many variations of formulas to return the above results without any success. Can anyone advise on the correct formula to enter? TIA Jan |
Formula help needed
You're welocme. Thanks for the feedback!
Biff "Jan" wrote in message ... Hi Biff, Thank you...that appears to work as needed. Jan "Jan" wrote: Excel 97. Column/Row B2 = text value Column/Row O2 = Date value I need a formula to evaluate as follows: If B2 & O2 contain no value return "", if B2 contains a value & O2 is null return 0 (zero), otherwise calculate today()-O2. I have been trying many variations of formulas to return the above results without any success. Can anyone advise on the correct formula to enter? TIA Jan |
All times are GMT +1. The time now is 10:09 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com