IF forumla

Sindad

New Member
Joined
Sep 7, 2014
Messages
2
I have this long rows and multiple columns where I want to do two IF equation.

[TABLE="width: 229"]
<colgroup><col></colgroup><tbody>[TR]
[TD]First request :

if cell e is green then do
d2-d3*-1 if cell e is red then d2-d3
[/TD]
[/TR]
</tbody>[/TABLE]

Second request :
If e 17 & m17 are both green, then do d17-d18*-1 but if e 17 & m17 are red, then do d17-d18



[TABLE="width: 1019"]
<colgroup><col span="4"><col><col><col><col><col><col><col span="2"><col></colgroup><tbody>[TR]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]COLOR[/TD]
[TD][/TD]
[TD]Request number 1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]1.60054[/TD]
[TD="align: right"]1.57619[/TD]
[TD="align: right"]1.58589[/TD]
[TD="align: right"]1.59594[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]1.60006[/TD]
[TD="align: right"]1.58829[/TD]
[TD="align: right"]1.59594[/TD]
[TD="align: right"]1.59394[/TD]
[TD][/TD]
[TD]if cell e is green then do d2-d3*-1 if cell e is red then d2-d3[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]1.59718[/TD]
[TD="align: right"]1.58485[/TD]
[TD="align: right"]1.59394[/TD]
[TD="align: right"]1.59052[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]1.59052[/TD]
[TD="align: right"]1.56928[/TD]
[TD="align: right"]1.59052[/TD]
[TD="align: right"]1.57679[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]1.57912[/TD]
[TD="align: right"]1.57063[/TD]
[TD="align: right"]1.57679[/TD]
[TD="align: right"]1.57334[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]1.57941[/TD]
[TD="align: right"]1.56719[/TD]
[TD="align: right"]1.57334[/TD]
[TD="align: right"]1.57279[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]1.58503[/TD]
[TD="align: right"]1.56589[/TD]
[TD="align: right"]1.57279[/TD]
[TD="align: right"]1.57919[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]1.58357[/TD]
[TD="align: right"]1.56742[/TD]
[TD="align: right"]1.57919[/TD]
[TD="align: right"]1.56813[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]1.57865[/TD]
[TD="align: right"]1.56813[/TD]
[TD="align: right"]1.56813[/TD]
[TD="align: right"]1.57474[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]1.57665[/TD]
[TD="align: right"]1.55924[/TD]
[TD="align: right"]1.57474[/TD]
[TD="align: right"]1.56044[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]1.54812[/TD]
[TD="align: right"]1.53424[/TD]
[TD="align: right"]1.54294[/TD]
[TD="align: right"]1.54709[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Request number 2[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]COLOR[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]COLOR[/TD]
[/TR]
[TR]
[TD="align: right"]1.60054[/TD]
[TD="align: right"]1.57619[/TD]
[TD="align: right"]1.58589[/TD]
[TD="align: right"]1.59594[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1.60054[/TD]
[TD="align: right"]1.57619[/TD]
[TD="align: right"]1.58589[/TD]
[TD="align: right"]1.59594[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]1.60006[/TD]
[TD="align: right"]1.58829[/TD]
[TD="align: right"]1.59594[/TD]
[TD="align: right"]1.59394[/TD]
[TD][/TD]
[TD]If e 17 & m17 are both green, then do d17-d18*-1 but if e 17 & m17 are red, then do d17-d18[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1.60006[/TD]
[TD="align: right"]1.58829[/TD]
[TD="align: right"]1.59594[/TD]
[TD="align: right"]1.59394[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]1.59718[/TD]
[TD="align: right"]1.58485[/TD]
[TD="align: right"]1.59394[/TD]
[TD="align: right"]1.59052[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1.59718[/TD]
[TD="align: right"]1.58485[/TD]
[TD="align: right"]1.59394[/TD]
[TD="align: right"]1.59052[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]1.59052[/TD]
[TD="align: right"]1.56928[/TD]
[TD="align: right"]1.59052[/TD]
[TD="align: right"]1.57679[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1.59052[/TD]
[TD="align: right"]1.56928[/TD]
[TD="align: right"]1.59052[/TD]
[TD="align: right"]1.57679[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]1.57912[/TD]
[TD="align: right"]1.57063[/TD]
[TD="align: right"]1.57679[/TD]
[TD="align: right"]1.57334[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1.57912[/TD]
[TD="align: right"]1.57063[/TD]
[TD="align: right"]1.57679[/TD]
[TD="align: right"]1.57334[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]1.57941[/TD]
[TD="align: right"]1.56719[/TD]
[TD="align: right"]1.57334[/TD]
[TD="align: right"]1.57279[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1.57941[/TD]
[TD="align: right"]1.56719[/TD]
[TD="align: right"]1.57334[/TD]
[TD="align: right"]1.57279[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]1.58503[/TD]
[TD="align: right"]1.56589[/TD]
[TD="align: right"]1.57279[/TD]
[TD="align: right"]1.57919[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1.58503[/TD]
[TD="align: right"]1.56589[/TD]
[TD="align: right"]1.57279[/TD]
[TD="align: right"]1.57919[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]1.58357[/TD]
[TD="align: right"]1.56742[/TD]
[TD="align: right"]1.57919[/TD]
[TD="align: right"]1.56813[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1.58357[/TD]
[TD="align: right"]1.56742[/TD]
[TD="align: right"]1.57919[/TD]
[TD="align: right"]1.56813[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]1.57865[/TD]
[TD="align: right"]1.56813[/TD]
[TD="align: right"]1.56813[/TD]
[TD="align: right"]1.57474[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1.57865[/TD]
[TD="align: right"]1.56813[/TD]
[TD="align: right"]1.56813[/TD]
[TD="align: right"]1.57474[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]1.57665[/TD]
[TD="align: right"]1.55924[/TD]
[TD="align: right"]1.57474[/TD]
[TD="align: right"]1.56044[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1.57665[/TD]
[TD="align: right"]1.55924[/TD]
[TD="align: right"]1.57474[/TD]
[TD="align: right"]1.56044[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]1.54812[/TD]
[TD="align: right"]1.53424[/TD]
[TD="align: right"]1.54294[/TD]
[TD="align: right"]1.54709[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1.54812[/TD]
[TD="align: right"]1.53424[/TD]
[TD="align: right"]1.54294[/TD]
[TD="align: right"]1.54709[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]












[TABLE="width: 229"]
<tbody>[TR]
[/TR]
</tbody>[/TABLE]
 

Excel Facts

Control Word Wrap
Press Alt+Enter to move to a new row in a cell. Lets you control where the words wrap.
what defines the cell colour is that CF or manual
 
Upvote 0
a conditional formatting, highlight cell E Green if cell D is bigger than C, or highlight E red if cell D is smaller than C
 
Upvote 0
If the cells are set by conditional formatting then use the SAME CONDITIONs that set the cell colour to determine the value in the cells.
 
Upvote 0

Forum statistics

Threads
1,223,430
Messages
6,172,053
Members
452,444
Latest member
ShaImran193

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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Back
Top