logic doubts

[nowfal]

I am using a work sheet for billing purpose, for that i need som
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 th
currency as USD i wanted the rate should be within .380 and .384. I
I put .385 the cell should not accept or otherwise i have to get som
warning message.

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

thanks in advance.
nowfa

 

[Frank Kabel]

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

 

[nowfal]

As Mr.Fank said, i had go through the validation process there again
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 US
, i wanted to set the rate in colomn E as between 0.380 and 0.384 . I
i am doing that through validation, there is a custom selection bu
there i need to put some formula, that i couldn't able to create. i
somebody helps it is good and nice.
by
nowfa

 

[Aladin Akyurek]

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.