IF function in Excel

[Gajendran Yadhav]

Dear experts,

I'm working on a file where I have any number of data and in one column (Column N) pertaining to Money Components.
This value is based on the data in the Column P.

I want the users to enter exact value.

The values in Column P are - CD, Civil, Criminal, FIR, WC, TPC (listed function)

I want values in column N to be dependent on column P.

If Column P is FIR or Criminal, Column N should be ZERO (0).
If column P is not FIR or Criminal, then any value greater than 0.

First four rows are title. first value is entered in row 5.

I used the following IF Function, however it failed.

=IF(OR(P5="FIR", P5="CRIMINAL"), 0, "*")

Please Help with Data Validation Formula.

And is there any possibility that Excel automatically calculates the value that I enter to lakhs (Indian System) or Millions.
Eg: if the value is 567891 (Five Lakh Sixty Seven Thousand Eight Hundred Ninty One), then it should return 5.67.

I have formatted the column N as "Currency" with Indian Rupee Symbol and with 2 decimal places.

Any help will be appreciated.

 

[Muhammad_Usman]

1235.xlsm
	N	O	P	Q	R	S	T
2						List
3						Fir	-
4	Monetry	By	class			Criminal	-
5	100.00	BY	Civil			CD	50
6	0.00	BY	Criminal			Civil	100
7	50.00	BY	CD			WU	200
8	0.00	BY	Fir			TPC	300
9	300.00	BY	TPC
10	0.00		Criminal
11	50.00		cd
12	300.00		TPC
13
14
15
Sheet17

Cell Formulas
Range	Formula
N5:N13	N5	=IFNA(INDEX($T$3:$T$8,MATCH(P5,$S$3:$S$8,0)),"")

Cells with Data Validation
Cell	Allow	Criteria
P5:P13	List	=$S$3:$S$8

 

[Gajendran Yadhav]

1235.xlsm
	N	O	P	Q	R	S	T
2						List
3						Fir	-
4	Monetry	By	class			Criminal	-
5	100.00	BY	Civil			CD	50
6	0.00	BY	Criminal			Civil	100
7	50.00	BY	CD			WU	200
8	0.00	BY	Fir			TPC	300
9	300.00	BY	TPC
10	0.00		Criminal
11	50.00		cd
12	300.00		TPC
13
14
15
Sheet17

Cell Formulas
Range	Formula
N5:N13	N5	=IFNA(INDEX($T$3:$T$8,MATCH(P5,$S$3:$S$8,0)),"")

Cells with Data Validation
Cell	Allow	Criteria
P5:P13	List	=$S$3:$S$8

Hi...Thanks for your help.

I could not understand your view... please give more clear information to understand better.