# Iff to calculate # of weeks, convert Excel

#### pete234

##### Active Member
I have a formula that works fine in Excel but can't seem to recreate in Access.

=IF(OR([@[Period]=3,[@[Period]]=6,[@[Period]]=9,[@[Period]]=12)=[Budget_Amount]/5,[Budget_Amount]/4)

this is what is in my Excel table, I just need weeks for custom fiscal table to make another calculation in a query.

### Excel Facts

Excel Wisdom
Using a mouse in Excel is the work equivalent of wearing a lanyard when you first get to college
=IIF(Period = 3 or Period = 6 or Period = 9 or Period = 12, [Budget_Amount]/5, [Budget_Amount]/4)

Try the above.

Alan

Replies
1
Views
560
Replies
3
Views
471
Replies
22
Views
2K
Replies
6
Views
252
Replies
11
Views
1K

1,207,011
Messages
6,076,145
Members
446,187
Latest member
LMill

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