# can if formula have another if formula inside the formula? sory for poor english! need help!

#### pedie

##### Well-known Member
If f1 i have a formula as below;
IF(OR(H11<13,OR(I11<3,J11<3,K11<3)),"Declined","Accept")
if g1 has word saturday can the formula show "Accept" but if in g1<> saturday then the formula ( IF(OR(H11<13,OR(I11<3,J11<3,K11<3)),"Declined","Accept") )
can someone please edit this fomula???

Thanks for looking into it.

### Excel Facts

What is the last column in Excel?
Excel columns run from A to Z, AA to AZ, AAA to XFD. The last column is XFD.

#### pedie

##### Well-known Member
Or should i edit like
IF(OR(H11<13,OR(I11<3,J11<3,K11<3,G1="saturday")),"Declined","Accept")

????

#### PCRIDE

##### Well-known Member

=if("G1="Saturday", "Accept",IF(OR(H11<13,OR(I11<3,J11<3,K11<3)),"Declined","Accept")

#### pedie

##### Well-known Member
can you please make changes again???

because no matter what the other part of formula may be if saturday is thee in g1 i dont want = <TABLE style="WIDTH: 48pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=64><COLGROUP><COL style="WIDTH: 48pt" width=64><TBODY><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; WIDTH: 48pt; HEIGHT: 15pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl63 height=20 width=64>IF(OR(H11<13,OR(I11<3,J11<3,K11<3,M11<>"Saturday")),"Declined","Accept")</TD></TR></TBODY></TABLE>
to be calculated.

if it is saturday in g1, no more calculation it should always show accept, but if g1 <> saturday then for
<TABLE style="WIDTH: 48pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=64><COLGROUP><COL style="WIDTH: 48pt" width=64><TBODY><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; WIDTH: 48pt; HEIGHT: 15pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 height=20 width=64>IF(OR(H11<13,OR(I11<3,J11<3,K11<3,M11<>"Saturday")),"Declined","Accept")</TD></TR></TBODY></TABLE>

Thanks again.

#### PCRIDE

##### Well-known Member
Is this a duplicate post?

#### pedie

##### Well-known Member

Replies
16
Views
188
Replies
3
Views
433
Replies
6
Views
227
Replies
5
Views
405
Replies
2
Views
269

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

1,163,459
Messages
5,831,760
Members
430,088
Latest member
meagerd

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