Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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
add comment

migrated from webapps.stackexchange.com Feb 28 '13 at 3:26

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

1 Answer

Try this formula:

=IF(A1="Overnight tour",INT(B5/16),"")
share|improve this answer
1  
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
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.