Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|