Creating a function which handles multiple true criteria

**ddman3** · 12-30-2015, 08:27 PM

Hello everyone,

I am wondering if someone may be able to offer a kind spot of advice. I can't seem to find any information relating to the query I am after. In essence I would like to achieve the formula as follows:

TRUE =IF(CELLBLANK then Calculate C1-C2 unless C3 is greater than C2 then calculate C1-C3
FALSE = C1-C4

Formula:

Please Login or Register  to view this content.

If anyone can help tidy this up and show a solution it would be great. The cells are dates. Therefore this should provide me the duration between the two. Thanks for your time.

**jewelsharma** · 12-30-2015, 08:37 PM

try the following formula:

Formula:

Please Login or Register  to view this content.

**FDibbins** · 12-30-2015, 08:49 PM

Maybe this...
=C1-IF(C4="",max(C2,C3),C4)

**jewelsharma** · 12-30-2015, 09:21 PM

Love this formula. Much simpler to follow.
Applause!

**FDibbins** · 12-30-2015, 09:37 PM

Thanks jewelsharma, really appreciate the feedback

Creating a function which handles multiple true criteria

LinkBack

Thread Tools

Rate This Thread

Display

Creating a function which handles multiple true criteria

Re: Creating a function which handles multiple true criteria

Re: Creating a function which handles multiple true criteria

Re: Creating a function which handles multiple true criteria

Re: Creating a function which handles multiple true criteria

Thread Information

Users Browsing this Thread

Similar Threads

Find text (multiple criteria) in multiple cells, return multiple values if true/false

[SOLVED] TRUE/FALSE Based on multiple criteria

[SOLVED] Multiple TRUE,FALSE criteria

Sum if multiple Criteria is true

SUMIF where multiple criteria are true?

Pie chart handles in the pivot table don't function

creating a function with multiple criteria

Bookmarks

Bookmarks

Posting Permissions