| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Multiple logical formula
i wud like to put this formula in excel,if someone can please guide me,
if c1a1 and if c1b1 then d1=0, if c1a1 and if c1<b1 then d1=c1-b1 if c1<a1 and if c1<b1 then d1=a1-b1 and if c1<a1 and c1b1 then d1=a1-c1 -- thanks and rgds amit |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Multiple logical formula
Try this: in D1
=IF(AND(C1A1,C1B1),0,IF(AND(C1A1,C1<B1),C1-B1,IF(AND(C1<A1,C1<B1),A1-B1,IF(AND(C1<A1,C1B1),A1-C1,"Unspecified")))) Will that do? Mike "spaceage" wrote: i wud like to put this formula in excel,if someone can please guide me, if c1a1 and if c1b1 then d1=0, if c1a1 and if c1<b1 then d1=c1-b1 if c1<a1 and if c1<b1 then d1=a1-b1 and if c1<a1 and c1b1 then d1=a1-c1 -- thanks and rgds amit |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Multiple logical formula
Great help Mike, thanks a million.
-- rgds "Mike" wrote: Try this: in D1 =IF(AND(C1A1,C1B1),0,IF(AND(C1A1,C1<B1),C1-B1,IF(AND(C1<A1,C1<B1),A1-B1,IF(AND(C1<A1,C1B1),A1-C1,"Unspecified")))) Will that do? Mike "spaceage" wrote: i wud like to put this formula in excel,if someone can please guide me, if c1a1 and if c1b1 then d1=0, if c1a1 and if c1<b1 then d1=c1-b1 if c1<a1 and if c1<b1 then d1=a1-b1 and if c1<a1 and c1b1 then d1=a1-c1 -- thanks and rgds amit |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Multiple logical formula
Your welcome and thaks for the feedback. Just one point you need to consider
what you want to happen if c1 = a1& b1 because you don't specify this. In my formula this condition returns 'Unspecified" Mike "spaceage" wrote: Great help Mike, thanks a million. -- rgds "Mike" wrote: Try this: in D1 =IF(AND(C1A1,C1B1),0,IF(AND(C1A1,C1<B1),C1-B1,IF(AND(C1<A1,C1<B1),A1-B1,IF(AND(C1<A1,C1B1),A1-C1,"Unspecified")))) Will that do? Mike "spaceage" wrote: i wud like to put this formula in excel,if someone can please guide me, if c1a1 and if c1b1 then d1=0, if c1a1 and if c1<b1 then d1=c1-b1 if c1<a1 and if c1<b1 then d1=a1-b1 and if c1<a1 and c1b1 then d1=a1-c1 -- thanks and rgds amit |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Multiple logical formula
Try this:
=IF(AND(C1A1,C1B1),D1=0,IF(AND(C1A1,C1<B1),D1=C 1-B1,IF(AND(C1<A1,C1<B1),D1=A1-B1,IF(AND(C1<A1,C1B1),D1=A1-C1)))) -- sandyboy "spaceage" wrote: i wud like to put this formula in excel,if someone can please guide me, if c1a1 and if c1b1 then d1=0, if c1a1 and if c1<b1 then d1=c1-b1 if c1<a1 and if c1<b1 then d1=a1-b1 and if c1<a1 and c1b1 then d1=a1-c1 -- thanks and rgds amit |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Multiple logical formula
Hi,
thanks a lot for ur help. -- rgds "sandyboy" wrote: Try this: =IF(AND(C1A1,C1B1),D1=0,IF(AND(C1A1,C1<B1),D1=C 1-B1,IF(AND(C1<A1,C1<B1),D1=A1-B1,IF(AND(C1<A1,C1B1),D1=A1-C1)))) -- sandyboy "spaceage" wrote: i wud like to put this formula in excel,if someone can please guide me, if c1a1 and if c1b1 then d1=0, if c1a1 and if c1<b1 then d1=c1-b1 if c1<a1 and if c1<b1 then d1=a1-b1 and if c1<a1 and c1b1 then d1=a1-c1 -- thanks and rgds amit |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Multiple logical formula
=IF(C1A1,IF(C1B1,0,C1-B1),IF(C1<B1,A1-B1,A1-C1))
or =IF(C1A1,MIN(C1-B1,0),A1-MAX(B1,C1)) Note that you didn't specify what happens if C1=A1, or if C1=B1. -- David Biddulph "spaceage" wrote in message ... i wud like to put this formula in excel,if someone can please guide me, if c1a1 and if c1b1 then d1=0, if c1a1 and if c1<b1 then d1=c1-b1 if c1<a1 and if c1<b1 then d1=a1-b1 and if c1<a1 and c1b1 then d1=a1-c1 -- thanks and rgds amit |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Multiple logical formula
hi david,
what will be ans in that case if C1=A1, or if C1=B1. -- rgds amit "David Biddulph" wrote: =IF(C1A1,IF(C1B1,0,C1-B1),IF(C1<B1,A1-B1,A1-C1)) or =IF(C1A1,MIN(C1-B1,0),A1-MAX(B1,C1)) Note that you didn't specify what happens if C1=A1, or if C1=B1. -- David Biddulph "spaceage" wrote in message ... i wud like to put this formula in excel,if someone can please guide me, if c1a1 and if c1b1 then d1=0, if c1a1 and if c1<b1 then d1=c1-b1 if c1<a1 and if c1<b1 then d1=a1-b1 and if c1<a1 and c1b1 then d1=a1-c1 -- thanks and rgds amit |
|
#9
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Multiple logical formula
One way:
=MAX(A1,C1)-MAX(B1,C1) Tim C "spaceage" wrote in message ... i wud like to put this formula in excel,if someone can please guide me, if c1a1 and if c1b1 then d1=0, if c1a1 and if c1<b1 then d1=c1-b1 if c1<a1 and if c1<b1 then d1=a1-b1 and if c1<a1 and c1b1 then d1=a1-c1 -- thanks and rgds amit |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need help about logical formula | Excel Worksheet Functions | |||
| Excel Conditional Formatting color multiple cells for 1 logical | Excel Worksheet Functions | |||
| How do I set up multiple logical conditions on one result cell | Excel Worksheet Functions | |||
| LOGICAL FUNCTIONS WITH MULTIPLE VARIABLES | Excel Worksheet Functions | |||
| Logical Function - Multiple IF statements | Excel Worksheet Functions | |||
Hybrid Mode
