#### lee.ellis

##### New Member
Hi

I would like to add a specific amount to the sum of two columns if the sum returns a value greater than 0.

e.g Column A1=variable amount Column B1=A1*100 Column C1=B1+500 IF B1>0

I'm using Office 2003

Thanks

Lee

### Excel Facts

Best way to learn Power Query?
Read M is for (Data) Monkey book by Ken Puls and Miguel Escobar. It is the complete guide to Power Query.

#### Mike Blackman

##### Well-known Member
Hi,

Try;

=IF(B1>0,B1+500,B1)

or alternatively

=B1+(500*(B1>0))

#### lee.ellis

##### New Member
Many thanks to both of you!! think i'll book myself on that excel course now!

Enjoy the rest of your day.

Lee

Replies
3
Views
44
Replies
13
Views
361
Replies
0
Views
203
Replies
5
Views
188
Replies
3
Views
29

1,191,527
Messages
5,987,106
Members
440,079
Latest member
MarchePR

### 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