View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Malik Nadeem Malik Nadeem is offline
external usenet poster
 
Posts: 44
Default 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