How can I do this?

N

nd2no

l2 = # of miles. q4 = bonus.

How can I make q4 show the bonus based on the following:

10,000 miles = $50
15,000 miles = $75
20,000 miles = $100

Thanks for your time
 
P

Peo Sjoblom

Please refrain from multiposting, see answer in new users

--


For everyone's benefit keep the discussion in the newsgroup.

Regards,

Peo Sjoblom
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Calculate end date and time 1
How can I do this? 5
Secondary axis alignment 0
How do I 2
help w indirect and index,match 3
A couple questions BEFORE using Office 365 0
In Excel, how do I display a leading zero? e.g. 05 for 5 ? 1
Excel Countif Function - Calculating Between Two Sets of Values 3

Top