| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
pre determine value
Can you look at the example below and provide me with the solution? Would
appreciate your help in this mater. EXAMPLE A B C D E F ====================================== 1 1000 ANY VALUE 5 16/05 10 =IF(A10, 1000-10, "") 2 ........................... 3 ............................... 4 .................................................. ... 5 .................................................. .................. HINTS I WANT ALLOCATE VALUE TO B1, C1, D1 & E1 IS EQUAL TO 10 ITS MEAN IF B1 or C1 or D1 or E1 is grater then 0 (zero) then formula will work but i can work only with one cell like above how can extand this formule in same cell i.e. F1 Regards Malik Nadeem 0092 300 2556512 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
pre determine value
Do you mean if ANY of the values in B1:E1 are greater than 0 OR if ALL
the values in B1:E1 are greater than 0? And whichever of these is correct, do you then want to subtract 10 from A1 or set F1 to 990 irrespective of the value of A1? Pete On Sep 19, 10:54 am, Malik Nadeem wrote: Can you look at the example below and provide me with the solution? Would appreciate your help in this mater. EXAMPLE A B C D E F ====================================== 1 1000 ANY VALUE 5 16/05 10 =IF(A10, 1000-10, "") 2 ........................... 3 ............................... 4 .................................................. ... 5 .................................................. .................. HINTS I WANT ALLOCATE VALUE TO B1, C1, D1 & E1 IS EQUAL TO 10 ITS MEAN IF B1 or C1 or D1 or E1 is grater then 0 (zero) then formula will work but i can work only with one cell like above how can extand this formule in same cell i.e. F1 Regards Malik Nadeem 0092 300 2556512 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
pre determine value
thanks for reply pete.
actualy you are not getting my point what i m asking ? look i need that formula which i will put in F1 column NOW HOW IT WILL WORK? when i put any value in B1 Aswer show by F1 is 990 when i put any value in B2 aswer show by F1 is 980 CHECK when i delete the value in B1 result come back to 990 instead of 980. simply value B1 To F1 is 40 (B1=10 + C1=10 + D1=10 + E1=10) equal to 40 (B1=(cell Empty) + C1=10 + D1=10 + E1=10) equal to 30 or may be following line will help you to understand the actual question when any cell from B1:E1 not grater then 0 then formula 1st formula check to B1 if found any value substract from A1 then go to next cell i.e. C1 check if found then substract an other value of 10 from previous result instead of A1 value beacuse A1 value was 1000 and previous result is 990 due to already substracted from B1 and same go to next cell C1 if found value substract value of 10 from previous result that was 980 instead of A1 value which is 1000 NOtE: i am having dificulty in try to explain the problem to my friends in my native language. please help in resolving and try to understand. if still un celared then please feel free to revert me my personal email address is "Pete_UK" wrote: Do you mean if ANY of the values in B1:E1 are greater than 0 OR if ALL the values in B1:E1 are greater than 0? And whichever of these is correct, do you then want to subtract 10 from A1 or set F1 to 990 irrespective of the value of A1? Pete On Sep 19, 10:54 am, Malik Nadeem wrote: Can you look at the example below and provide me with the solution? Would appreciate your help in this mater. EXAMPLE A B C D E F ====================================== 1 1000 ANY VALUE 5 16/05 10 =IF(A10, 1000-10, "") 2 ........................... 3 ............................... 4 .................................................. ... 5 .................................................. .................. HINTS I WANT ALLOCATE VALUE TO B1, C1, D1 & E1 IS EQUAL TO 10 ITS MEAN IF B1 or C1 or D1 or E1 is grater then 0 (zero) then formula will work but i can work only with one cell like above how can extand this formule in same cell i.e. F1 Regards Malik Nadeem 0092 300 2556512 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
pre determine (revised)
revised msg amendment in line number 7
C1 instead of B2 thanks for reply pete. actualy you are not getting my point what i m asking ? look i need that formula which i will put in F1 column NOW HOW IT WILL WORK? when i put any value in B1 Aswer show by F1 is 990 when i put any value in B2 aswer show by F1 is 980 CHECK when i delete the value in B1 result come back to 990 instead of 980. simply value B1 To F1 is 40 (B1=10 + C1=10 + D1=10 + E1=10) equal to 40 (B1=(cell Empty) + C1=10 + D1=10 + E1=10) equal to 30 or may be following line will help you to understand the actual question when any cell from B1:E1 not grater then 0 then formula 1st formula check to B1 if found any value substract from A1 then go to next cell i.e. C1 check if found then substract an other value of 10 from previous result instead of actual value of A1 beacuse now A1 is not a 1000 it 990 bcz already substracted through B1 and same go to next cell C1 if found value substract value of 10 from previous result that was 980 instead of A1 value which is 1000 PLZ SEE FOLLOWING EXAMPLES A B C D E F ====================================== 1000 mike 10 10/06 2 = (960) A B C D E F ====================================== 1000 10 10/06 2 = (970) A B C D E F ====================================== 1000 10/06 2 = (980) A B C D E F ====================================== 1000 2 = (990) A B C D E F ====================================== 1000 = (1000) NOtE: i am having dificulty in try to explain the problem to my friends in my native language. please help in resolving and try to understand. if still un celared then please feel free to revert me my personal email address is "Pete_UK" wrote: Do you mean if ANY of the values in B1:E1 are greater than 0 OR if ALL the values in B1:E1 are greater than 0? And whichever of these is correct, do you then want to subtract 10 from A1 or set F1 to 990 irrespective of the value of A1? Pete On Sep 19, 10:54 am, Malik Nadeem wrote: Can you look at the example below and provide me with the solution? Would appreciate your help in this mater. EXAMPLE A B C D E F ====================================== 1 1000 ANY VALUE 5 16/05 10 =IF(A10, 1000-10, "") 2 ........................... 3 ............................... 4 .................................................. ... 5 .................................................. .................. HINTS I WANT ALLOCATE VALUE TO B1, C1, D1 & E1 IS EQUAL TO 10 ITS MEAN IF B1 or C1 or D1 or E1 is grater then 0 (zero) then formula will work but i can work only with one cell like above how can extand this formule in same cell i.e. F1 Regards Malik Nadeem 0092 300 2556512 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
pre determine (revised)
revised msg amendment in line number 7
C1 instead of B2 thanks for reply pete. actualy you are not getting my point what i m asking ? look i need that formula which i will put in F1 column NOW HOW IT WILL WORK? when i put any value in B1 Aswer show by F1 is 990 when i put any value in B2 aswer show by F1 is 980 CHECK when i delete the value in B1 result come back to 990 instead of 980. simply value B1 To F1 is 40 (B1=10 + C1=10 + D1=10 + E1=10) equal to 40 (B1=(cell Empty) + C1=10 + D1=10 + E1=10) equal to 30 or may be following line will help you to understand the actual question when any cell from B1:E1 not grater then 0 then formula 1st formula check to B1 if found any value substract from A1 then go to next cell i.e. C1 check if found then substract an other value of 10 from previous result instead of actual value of A1 beacuse now A1 is not a 1000 it 990 bcz already substracted through B1 and same go to next cell C1 if found value substract value of 10 from previous result that was 980 instead of A1 value which is 1000 PLZ SEE FOLLOWING EXAMPLES A B C D E F ====================================== 1000 mike 10 10/06 2 = (960) A B C D E F ====================================== 1000 10 10/06 2 = (970) A B C D E F ====================================== 1000 10/06 2 = (980) A B C D E F ====================================== 1000 2 = (990) A B C D E F ====================================== 1000 = (1000) NOtE: i am having dificulty in try to explain the problem to my friends in my native language. please help in resolving and try to understand. if still un celared then please feel free to revert me my personal email address is "Pete_UK" wrote: Do you mean if ANY of the values in B1:E1 are greater than 0 OR if ALL the values in B1:E1 are greater than 0? And whichever of these is correct, do you then want to subtract 10 from A1 or set F1 to 990 irrespective of the value of A1? Pete On Sep 19, 10:54 am, Malik Nadeem wrote: Can you look at the example below and provide me with the solution? Would appreciate your help in this mater. EXAMPLE A B C D E F ====================================== 1 1000 ANY VALUE 5 16/05 10 =IF(A10, 1000-10, "") 2 ........................... 3 ............................... 4 .................................................. ... 5 .................................................. .................. HINTS I WANT ALLOCATE VALUE TO B1, C1, D1 & E1 IS EQUAL TO 10 ITS MEAN IF B1 or C1 or D1 or E1 is grater then 0 (zero) then formula will work but i can work only with one cell like above how can extand this formule in same cell i.e. F1 Regards Malik Nadeem 0092 300 2556512 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to determine the value? | Excel Discussion (Misc queries) | |||
| How to determine the value? | Excel Discussion (Misc queries) | |||
| How to determine the value? | Excel Worksheet Functions | |||
| How to determine the value? | Excel Discussion (Misc queries) | |||
| How to Determine 1st, 2nd & 3rd for a PWD | Excel Discussion (Misc queries) | |||
Hybrid Mode
