Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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) |