A
Akash
Hi,
I have a sheet in which i have few columns
1. FH
2. FL
3. RD
4. FPI
5. QTY
6. COMPUTE
NOW I WANT THAT AS SOON AS I THE USER ENTER THE VALUES IN THE COLUMNS
(FH, FL, RD, FPI, QTY) IT SHOULD COMPUTE THE BELOW MENTIONED FORMULAE.
COMPUTE = IF(TRIM(D8)="","",(((FH*FL*RD)/144*QTY)))
HOW CAN I DO THIS WITH THE HELP OF THE FORMULAE.
I WANTED THIS FUNCTION AS THE FORMULAE GETS DELETED BY THE USERS AND
THEN I HAD TO CHECK OUT THE ENTIRE FORMAT TO RECTIFY THE DATA.
PLS DO HELP ME IN THIS REGARDS
THANKS IN ADVANCE
AKASH
I have a sheet in which i have few columns
1. FH
2. FL
3. RD
4. FPI
5. QTY
6. COMPUTE
NOW I WANT THAT AS SOON AS I THE USER ENTER THE VALUES IN THE COLUMNS
(FH, FL, RD, FPI, QTY) IT SHOULD COMPUTE THE BELOW MENTIONED FORMULAE.
COMPUTE = IF(TRIM(D8)="","",(((FH*FL*RD)/144*QTY)))
HOW CAN I DO THIS WITH THE HELP OF THE FORMULAE.
I WANTED THIS FUNCTION AS THE FORMULAE GETS DELETED BY THE USERS AND
THEN I HAD TO CHECK OUT THE ENTIRE FORMAT TO RECTIFY THE DATA.
PLS DO HELP ME IN THIS REGARDS
THANKS IN ADVANCE
AKASH