# Formula gives me #value

#### howard

##### Well-known Member
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 Facts

Select a hidden cell
Somehide hide payroll data in column G? Press F5. Type G1. Enter. Look in formula bar while you arrow down through G.

#### JackDanIce

##### Well-known Member
Try:
Code:
``=IFERROR(ROUND(L2+IF(Len(M2)=0,N2,O2),0),L2)``

#### AlanY

##### Well-known Member
try this in Q2 and copy down

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

btw, 16.67% inc!
are you hiring?

#### howard

##### Well-known Member
Thanks for your input, much appreciated

BTW Alan unfortunately this is only fictitious data

Replies
0
Views
264
Replies
5
Views
135
Replies
12
Views
603
Replies
13
Views
1K
Replies
0
Views
498

1,140,917
Messages
5,703,167
Members
421,279
Latest member
emzy

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back