Nowfal,

Could you not just add the formula to F instead, it works just as well
there. I would avoid duplicating it if I possibly could.

How will this tolerance rate interact with the actual rates and the formula
that you require?

--

HTH

RP
(remove nothere from the email address if mailing direct)


"nowfal" wrote in
message ...

Hi bob,
It is working perfectly, but i wanted some more help. which
is very crucial for to complete the work. The rates shown in the table
is the standard rate, it may change or i have to give some better rates
to the customer sometimes. so there is a discount limit of both ways
plus and minus. I can say as tolerance limit. now the table is as
follows
CURRENCY / PURCHASE/ SALE/ TOLERANCE LIMIT
USD ---- 384 ----- 386 ------------------2
GBP ------ 685------- 700-----------------3
EUR----------- 480-------490--------------5
INR-----------8 ----------9-----------------0.5
THB----------9 ----------10----------------0.3
AED-------104-----------105--------------0.3
SAR-------102-----------103-------------0.5

The problem is i have given the formula in cell E, if i started change
the rate or anything on E will erase the formula . Instead my mind is
going in the other way create a duplicate row in sheet 2 itself (like
the one in sheet 1) and call back .
what is your opinion? Is there any other way? I know you can help me ,
b coz you sorted so many problems earlier too. Others also welcome.
thanks in advance
with regards
NOWFAL


--
nowfal
------------------------------------------------------------------------
nowfal's Profile:
http://www.excelforum.com/member.php...o&userid=10003
View this thread: http://www.excelforum.com/showthread...hreadid=399926