Formula gives me #value

[howard]

I have a formula in Col Q =IF(AND(M2="",O2="","",ROUND(L2+N2,0)),ROUND(L2+O2,0)) which gives me #value


I have basic salaries in Col L from row 2 onwards



I can either Input a % increase in Col M and the increased value will be computed in Col N or I can input a $ value in Col O and the % increase will be computed in Col P

I need to compute the new salary on either the Value in Col N if calculated or Col O if manually inputted



It would be apreciated if someone can please assist me

Excel 2010
	L	M	N	O	P	Q	R
1	CURR BASIC	% Inc	Value (Calc)	Value (Input)	% inc Calc	New Sal	Should Be
2	8150	5.00%	407.50			#VALUE!	8,557.50
3	3000			500.00	16.67%	#VALUE!	3,500.00
4	7850	6.00%	471.00			#VALUE!	8,321.00
5
Sheet1

Cell Formulas
Range	Formula
P2	=IF(O2="","",O2/L2)
P3	=IF(O3="","",O3/L3)
P4	=IF(O4="","",O4/I3)
Q2	=N1=IF(AND(M2="",O2="","",ROUND(L2+N2,0)),ROUND(L2+O2,0))
Q3	=IF(AND(M3="",O3="","",ROUND(L3+N3,0)),ROUND(L3+O3,0))
Q4	=IF(AND(M4="",O4="","",ROUND(L4+N4,0)),ROUND(L4+O4,0))
R2	=+L2+N2
R3	=+L3+O3
R4	=+L4+N4
N2	=IF(M2="","",L2*M2)
N3	=IF(M3="","",L3*M3)
N4	=IF(M4="","",L4*M4)

 

[JackDanIce]

Try:

=IFERROR(ROUND(L2+IF(Len(M2)=0,N2,O2),0),L2)

 

[AlanY]

try this in Q2 and copy down

=if(isblank(P2),L2+N2,L2+O2)

 

[AlanY]

btw, 16.67% inc!
are you hiring?

 

[howard]

Thanks for your input, much appreciated

BTW Alan unfortunately this is only fictitious data