If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 Different Functions in One Cell Cancel Each Other Out - How can I fix this?
 Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

## Different Functions in One Cell Cancel Each Other Out - How can I fix this?

#1
May 25th 12, 07:11 PM
 ljuarez12 Junior Member First recorded activity by ExcelBanter: May 2012 Posts: 1
Different Functions in One Cell Cancel Each Other Out - How can I fix this?

Hi, Please help. I have tried to setup my formulas in so many ways and still cannot get the results. If I move them to different cells they work independently however once I place them together the first cancels the second one out and it does not work. Here is the sample.

A1 = Initial Date (Manually Entered)
B1 = Initial Due Date (Calculated via Formula =IF(AND(A1<>"",F1<>""),"",IF(ISNUMBER(A1),(+A1+60) ,""))
C1 = Date of Completed Report (Manually Entered)
D1 = Meeting Due Date = (Calculated via Formula)
F1 = Transfer Date (not really need for this sample)

Formula(s) for D1 should state, if user enters a date in A1 then it should calculate B1 plus 30 days. Then if user enters a date in C1, it needs to compare the dates between C1 and B1 and if C1 is less than B1 then it should calculate C1 plus 30 days (in other words if the date of report was completed prior to the due date then a new one needs to be calculated).

Here is the formula I have now...again, I tried to change it up but this was my last one I tried using and it just gave me a False as a return statement. =IF(ISNUMBER(A1),(+B1+30)&IF(C1<B1,+C1+30,""))
#2
May 25th 12, 11:12 PM posted to microsoft.public.excel.worksheet.functions
 joeu2004[_2_] external usenet poster Posts: 637
Different Functions in One Cell Cancel Each Other Out - How can I fix this?

"ljuarez12" > wrote:
> A1 = Initial Date (Manually Entered)
> B1 = Initial Due Date (Calculated via Formula
> =IF(AND(A1<>"",F1<>""),"",IF(ISNUMBER(A1),(+A1+60) ,""))

Presumably, B1 should be:

=IF(OR(A1="",F1=""),"",IF(ISNUMBER(A1),A1+60,""))

although I don't know what F1 has to do with it. But that can be simplified
as follows:

=IF(OR(ISNUMBER(A1)=FALSE,F1=""),"",A1+60)

formatted as Date.

"ljuarez12" > wrote:
> C1 = Date of Completed Report (Manually Entered)
> D1 = Meeting Due Date = (Calculated via Formula)
> F1 = Transfer Date (not really need for this sample)
>
> Formula(s) for D1 should state, if user enters a date in A1 then it
> should calculate B1 plus 30 days. Then if user enters a date in C1, it
> needs to compare the dates between C1 and B1 and if C1 is less than B1
> then it should calculate C1 plus 30 days

D1 should be:

=IF(ISNUMBER(B1),IF(ISNUMBER(C1),MIN(B1+30,C1+30), B1+30),"")

formatted as Date.

Note that B1 is not a date if A1 is not a date (or F1 appears blank), so it
is not necessary to test A1 separately here.

 Thread Tools Display Modes Linear Mode

 Posting Rules You may not post new threads You may not post replies You may not post attachments You may not edit your posts vB code is On Smilies are On [IMG] code is On HTML code is Off
 Forum Jump User Control Panel Private Messages Subscriptions Who's Online Search Forums Forums Home Excel Newsgroups     Excel Discussion (Misc queries)     Setting up and Configuration of Excel     New Users to Excel     Excel Worksheet Functions     Links and Linking in Excel     Charts and Charting in Excel     Excel Programming About ExcelBanter     About this forum

 Similar Threads Thread Thread Starter Forum Replies Last Post Workbook_BeforeClose(Cancel As Boolean) - Cancel won't work gpmichal Setting up and Configuration of Excel 1 May 12th 09 02:33 AM Input box to cancel sub when Cancel is clicked. PCLIVE Excel Programming 5 September 5th 06 03:19 PM Disabling 'Cancel' option when saving work (Yes/No/Cancel) [email protected] Excel Programming 0 July 11th 06 09:28 PM Cancel button to cancel the whole macro excelnut1954 Excel Programming 3 January 17th 06 08:27 PM Cancel Macro is user selects 'cancel' at save menu Mark Excel Programming 1 April 6th 05 05:45 PM

All times are GMT +1. The time now is 04:15 PM.