# If Formula

#### honeybun

##### New Member
I wonder if any one can help me with the below please

I have two work sheets one which registers a day as Hol, and one which needs to register the seem information as the number of hours holiday taken, The people using this spreadsheet need to only have to enter the hol on to the one sheet and the rest need to auto fill, I have tried the following
=IF(Year!I8=Hol,7,0)

however this just brings me up the name error, any ideas?

### Excel Facts

Square and cube roots
The =SQRT(25) is a square root. For a cube root, use =125^(1/3). For a fourth root, use =625^(1/4).
Could try

=IF(Year!I8="Hol",7,0)

I think i have found it, thanks any way guys

Replies
0
Views
164
Replies
11
Views
416
Replies
5
Views
490
Replies
5
Views
257
Replies
2
Views
192

1,203,605
Messages
6,056,269
Members
444,853
Latest member
sam69

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