Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I would like to create a formula on excel 2007 as follows:

if (A1)="Overnight tour" I want the following calculation to take place (B1>15,1),(B1>31,2),(B1>47,3),(B1>63,4) and so on .. or maybe the multiplies of 16 to return 1 for each multiply in another form. otherwise (if A1 does not contain "Overnight tour") to return a blank cell ("").

Can anyone please help me with that

share|improve this question

migrated from Feb 28 '13 at 3:26

This question came from our site for power users of web applications.

Try this formula:

=IF(A1="Overnight tour",INT(B5/16),"")
share|improve this answer
Needs to be like this I think =IF(A1="Overnight tour",INT(B1/16),"") – barry houdini Feb 28 '13 at 16:34
@barryhoudini: What would I do without you!? ;-) Thanks! – Peter Albert Feb 28 '13 at 19:48

You must log in to answer this question.