#### hilaryval

##### New Member
Hi there,

I have this formula, which seems to work for the function I'm wanting: C81 =(C80*1.02)+D74
Except, if D74 is positive, I'd like to add just D74/2 to C81,

In mirror image for the next row, -C82 - I'd like none of D74 to be added if it is negative, but half to be added if positive.

Ie if D74 is positive, it gets split between the two rows. If negative, row 81 takes it.

Could someone help me in adding this 'IF' part to this formula?

Thank you so much!

### Excel Facts

Whats the difference between CONCAT and CONCATENATE?
The newer CONCAT function can reference a range of cells. =CONCATENATE(A1,A2,A3,A4,A5) becomes =CONCAT(A1:A5)

#### mikerickson

##### MrExcel MVP
C81 =(C80*1.02)+MIN(D74/2, D74)

for C82, you could use the term MAX(0,D74/2)

#### hilaryval

##### New Member
Mike that's brilliant - works perfectly. Thank you so much - you just saved me hours! I hadn't used MIN/MAX before.. Thanks!

Replies
4
Views
209
Replies
6
Views
100
Replies
6
Views
433
Replies
4
Views
382
Replies
1
Views
479

1,127,491
Messages
5,625,075
Members
416,068
Latest member
seba_s

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