PLZ USE V LOOKUP...
On Wed, Nov 18, 2009 at 12:48 PM, Anil Saxena wrote:
>
> Hi All
>
> Plz suggest me how to use formula like these e. g. when i written any names
> automatically put value.
>
>
>
>Anil 100 Saxena 90 Guni 80 Sonu 70 Yash 60 Thakur 50 Mathur 40
>
> --
>
> -
YOu need a Dlookup or a Custom List.
On Wed, Nov 18, 2009 at 2:18 AM, Anil Saxena wrote:
>
> Hi All
>
> Plz suggest me how to use formula like these e. g. when i written any names
> automatically put value.
>
>
>
>Anil 100 Saxena 90 Guni 80 Sonu 70 Yash 60 Thakur 50 Mathur 40
>
> --
>
> -
Hi Anil,
Use below logic:-
*Names Formula*
a 100 b =IF(A2="","",B1-10) c =IF(A3="","",B2-10)
Best Regards,
--
DILIP KUMAR PANDEY
MBA-HR,B COM(Hons.),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 110062
On Wed, Nov 18, 2009 at 12:48 P
