Formula

[Guest]

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

PLZ SEE FOLLOWING EXAMPLES FOR UNDERSTANDING PURPOSE
A B C D E F
(ANSWERThrough FORMULA)
======================================
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)

an prompt action will be reqire..
Malik Nadeem
0092 300 2556512

 

[Guest]

Maybe this could work.

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.


In Cell F1:
=1000-(COUNTA($B:$B)-1)*10

HTH.