pre determine value

[Guest]

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(A1>0,
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

 

[Pete_UK]

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

 

[Guest]

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 (e-mail address removed)

 

[Guest]

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)

 

[Guest]

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)