Conditional Formula Question

J

Jeremy

I need to set up a formula that allows the following:

79 or less = 0
80=80
81=81
82=82
100=100
101=102
102=104
103=106
104=108
105=110

Can anyone help?

Thanks
 
J

Jeremy

I have a formula that is set in the cell that will result in 101 however If
that happens i need it to say 102
 

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

Sort data 2
Cross-Referencing Data 0
SUMIF using criteria from a list 4
Formula for hiest rate 7
Find and Replace Cell Values 3
Query 1
Source and Destination 1
Copy in order 3

Top