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