Excel Help with a simple 'IF' function - Contractor UK Bulletin Board

Visitors can check out the Forum FAQ by clicking this link. You have to register before you can post: click the REGISTER link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. View our Forum Privacy Policy.
Want to receive the latest contracting news and advice straight to your inbox? Sign up to the ContractorUK newsletter here. Every sign up will also be entered into a draw to WIN £100 Amazon vouchers!

You are not logged in or you do not have permission to access this page. This could be due to one of several reasons:

You are not logged in. If you are already registered, fill in the form below to log in, or follow the "Sign Up" link to register a new account.
You may not have sufficient privileges to access this page. Are you trying to edit someone else's post, access administrative features or some other privileged system?
If you are trying to post, the administrator may have disabled your account, or it may be awaiting activation.

Hiram King Of Tyre replied

9 October 2013, 11:04
Thanks
Leave a comment:
DirtyDog replied

9 October 2013, 11:03
Originally posted by hiram king of tyre View Post

thanks chaps.

If i only want to do this if the value of another cell (say b1)=uk, how do i do that?

Code:

=if(b1="UK",if(month(a1)=9,1,""),"")
Leave a comment:
Hiram King Of Tyre replied

9 October 2013, 10:58
Thanks chaps.

If I only want to do this if the value of another cell (say B1)=UK, how do I do that?
Leave a comment:
DirtyDog replied

9 October 2013, 10:45
Assuming the date is in column A, starting with A1:

Code:

=IF(MONTH(A1)=9,1,"")
Leave a comment:
alluvial replied

9 October 2013, 10:44
=if (month (A1)=9, 1, 0)

And then copy down to the rest should do it.
Leave a comment:
Hiram King Of Tyre started a topic Excel Help with a simple 'IF' function

9 October 2013, 10:26
Excel Help with a simple 'IF' function

I have a column that may contain data. If is does, the data will be in the format 29/09/2013 16:00:43

In another colums, I simply want to put a '1' in the cell if the first cell contains data.

It's not necessary but it would be nice if I could only insert the '1' if the month was '09'

Any excel boffins out there?
Tags: None

Working...

X