Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Formula problems
My problem is I am trying to create a formula that would calculate some
figures. FORMULA: - IF D15 is equal to D17:D20 display result, IF not display result D17:D20. all these results would be display in cell D16. many thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Formula problems
i am not sure whether u r looking this formula:
=IF(D15=SUM(D17:D20),D15,SUM(D17:D20)) " wrote: My problem is I am trying to create a formula that would calculate some figures. FORMULA: - IF D15 is equal to D17:D20 display result, IF not display result D17:D20. all these results would be display in cell D16. many thanks |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Formula problems
thanks it not what i am looking for it seems this formula added all the
data in the cell. What i am looking for if D15 value for example 1 equals to range D17, D18, D19, D20 value are all 1 then display value 1 in cell D16. If not display min value of D17:D20. many thanks for your help anyway Muhammed Rafeek M wrote: i am not sure whether u r looking this formula: =IF(D15=SUM(D17:D20),D15,SUM(D17:D20)) " wrote: My problem is I am trying to create a formula that would calculate some figures. FORMULA: - IF D15 is equal to D17:D20 display result, IF not display result D17:D20. all these results would be display in cell D16. many thanks |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Formula problems
Hi
In cell D16 try =IF(COUNT(D17:D20)=4,D15,MIN(D17:D20)) -- Regards Roger Govier wrote in message ps.com... thanks it not what i am looking for it seems this formula added all the data in the cell. What i am looking for if D15 value for example 1 equals to range D17, D18, D19, D20 value are all 1 then display value 1 in cell D16. If not display min value of D17:D20. many thanks for your help anyway Muhammed Rafeek M wrote: i am not sure whether u r looking this formula: =IF(D15=SUM(D17:D20),D15,SUM(D17:D20)) " wrote: My problem is I am trying to create a formula that would calculate some figures. FORMULA: - IF D15 is equal to D17:D20 display result, IF not display result D17:D20. all these results would be display in cell D16. many thanks |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Formula problems
Sorry
Meant to say =IF(COUNTIF(D17:D20,D15)=4,D15,MIN(D17:D20)) -- Regards Roger Govier "Roger Govier" wrote in message ... Hi In cell D16 try =IF(COUNT(D17:D20)=4,D15,MIN(D17:D20)) -- Regards Roger Govier wrote in message ps.com... thanks it not what i am looking for it seems this formula added all the data in the cell. What i am looking for if D15 value for example 1 equals to range D17, D18, D19, D20 value are all 1 then display value 1 in cell D16. If not display min value of D17:D20. many thanks for your help anyway Muhammed Rafeek M wrote: i am not sure whether u r looking this formula: =IF(D15=SUM(D17:D20),D15,SUM(D17:D20)) " wrote: My problem is I am trying to create a formula that would calculate some figures. FORMULA: - IF D15 is equal to D17:D20 display result, IF not display result D17:D20. all these results would be display in cell D16. many thanks |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Formula problems
Count would return 4 if there are numbers in all 4 cells. I think you meant
=IF(COUNTIF(D17:D20,D15)=4,D15,MIN(D17:D20)) -- Regards, Tom Ogilvy "Roger Govier" wrote: Hi In cell D16 try =IF(COUNT(D17:D20)=4,D15,MIN(D17:D20)) -- Regards Roger Govier wrote in message ps.com... thanks it not what i am looking for it seems this formula added all the data in the cell. What i am looking for if D15 value for example 1 equals to range D17, D18, D19, D20 value are all 1 then display value 1 in cell D16. If not display min value of D17:D20. many thanks for your help anyway Muhammed Rafeek M wrote: i am not sure whether u r looking this formula: =IF(D15=SUM(D17:D20),D15,SUM(D17:D20)) " wrote: My problem is I am trying to create a formula that would calculate some figures. FORMULA: - IF D15 is equal to D17:D20 display result, IF not display result D17:D20. all these results would be display in cell D16. many thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula Problems | Excel Discussion (Misc queries) | |||
aauugghhh...#div/o problems & various average formula problems | Excel Worksheet Functions | |||
formula problems | New Users to Excel | |||
formula problems | Excel Discussion (Misc queries) | |||
Formula Problems | Excel Discussion (Misc queries) |