logic doubts

I am using a work sheet for billing purpose, for that i need some
security options for certain cells where i put currency rates,
the format is as follows:

A B C D E
F
DATE P/S CURRENCY QANTTY RATE AMOUNT
11/4/4 P USD 100 .382
38.200

In the B column if i put p(purchase) and in C suppose i put the
currency as USD i wanted the rate should be within .380 and .384. If
I put .385 the cell should not accept or otherwise i have to get some
warning message.

Is there any formula or conditional formula which i can apply for
several currency selection. The B colomn P for purchase and S for
Sale.

thanks in advance.
nowfal


---
Message posted from http://www.ExcelForum.com/

Hi
use 'Data - Validation' for this. See:
http://www.contextures.com/xlDataVal01.html

--
Regards
Frank Kabel
Frankfurt, Germany


I am using a work sheet for billing purpose, for that i need some
security options for certain cells where i put currency rates,
the format is as follows:

A B C D E
F
DATE P/S CURRENCY QANTTY RATE AMOUNT
11/4/4 P USD 100 .382
38.200

In the B column if i put p(purchase) and in C suppose i put the
currency as USD i wanted the rate should be within .380 and .384.
If
I put .385 the cell should not accept or otherwise i have to get some
warning message.

Is there any formula or conditional formula which i can apply for
several currency selection. The B colomn P for purchase and S for
Sale.

thanks in advance.
nowfal


---
Message posted from http://www.ExcelForum.com/

As Mr.Fank said, i had go through the validation process there again i
am getting confused and not getting the result what i wanted.
In coloumn A ; DATE
coloumn B ; PURCHASE
coloumn C : CURRENCY
coloumn D : QUANTITY
coloumn E ; RATE
coloumn F : AMOUNT

My question is if coloumn B is PURCHASE and in coloumn C is having USD
, i wanted to set the rate in colomn E as between 0.380 and 0.384 . If
i am doing that through validation, there is a custom selection but
there i need to put some formula, that i couldn't able to create. if
somebody helps it is good and nice.
by
nowfal


---
Message posted from http://www.ExcelForum.com/

Do you have a rate table sorted on Currency like this

EURO ...
STERLING ...
USD .382
YEN ...
etc.?

If you do, you could apply a custom data validation on E... something like
this:

=E2=LOOKUP(C2,RATES)

where RATES the name of the sorted rate table.

"nowfal " wrote in message
...
I am using a work sheet for billing purpose, for that i need some
security options for certain cells where i put currency rates,
the format is as follows:

A B C D E
F
DATE P/S CURRENCY QANTTY RATE AMOUNT
11/4/4 P USD 100 .382
38.200

In the B column if i put p(purchase) and in C suppose i put the
currency as USD i wanted the rate should be within .380 and .384. If
I put .385 the cell should not accept or otherwise i have to get some
warning message.

Is there any formula or conditional formula which i can apply for
several currency selection. The B colomn P for purchase and S for
Sale.

thanks in advance.
nowfal


---
Message posted from http://www.ExcelForum.com/