Tech Support Guy banner
Cancel

Have 2 formulas in one cell and want to choice of which

1102 Views 4 Replies 2 Participants Last post by  excelhelp0809, 
E
Hi there,

I have 2 formulas in one cell and want a choice in which will populate.
EX. =DATEDIF(F12,TODAY(),"d") & "-" & DATEDIF(F12,G12,"d")
I want it to choose first formula if G12 does not have a date. REVISED: I am working on an on time delivery. I have the date the customer requested in "f" and I have the formula above in "g". "h" is the difference in days. If "F" (actual delivery date) is empty, I would like it to calculate the number of days with today's date (not really typed in cell). I would like the result to be 1 answer (either/or)

Thanks
Save
Like
Status
Not open for further replies.
1 - 5 of 5 Posts
etaf
=if(g12="", DATEDIF(F12,TODAY(),"d"), DATEDIF(F12,TODAY(),"d") & "-" & DATEDIF(F12,G12,"d") )
Save
Like
E
That still puts 2 answers in "h" column. I am looking for it to pick 1 if "g" is blank. If "g" is blank, I want it to use today's date.
Save
Like
etaf
not sure i understand now

=if( g12 = "" , today() , "now what formula to put here !")

so thats how you get today() if g is blank

now you have REVISED, and mention F

now if g is not blank - what do you want
Save
Like
E
Sorry, Please see line 13. once there is a date in "H", I would like there to only be 1 number in "I". Also if we ship early, is there a way to have negative days?

Attachments

Save
Like
1 - 5 of 5 Posts
Status
Not open for further replies.
Tech Support Guy
A forum community dedicated to tech experts and enthusiasts. Come join the discussion about articles, computer security, Mac, Microsoft, Linux, hardware, networking, gaming, reviews, accessories, and more!
Full Forum Listing
Explore Our Forums
Hardware Virus & Other Malware Removal Off Topic Lounge Thread Games & Discussion Networking
Top