# Conditional formula help!!!

#### eddy23

##### New Member
Hi
“ if cell 'main'!U7 contains a negative value(integer) then cell 'C'!I16 =B!I15+'C'!I10
ELSE IF
if cell 'main'!U7 contains a positive value(integer) then cell 'C'!I16 =B!I15-'C'!I10

thank you

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

#### schielrn

##### Well-known Member
In cell I16 put this formula:

=if(main!U7<0,B!I15+C!I10,B!I15-C!I10)

Hope that helps and I assume that B and C are sheet names and you are referring to column I?

Replies
3
Views
203
Replies
0
Views
99
Replies
5
Views
79
Replies
8
Views
141
Replies
1
Views
88

1,195,749
Messages
6,011,436
Members
441,614
Latest member
TiaGtz

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