Posible IF formula

H

Hanah

A2 can have 3 kind of values. Eg. 1000, 2000, or 3000. If A2 is 1000, B2 is
140, if A2 is 2000, B2 is 14, if A2 is 3000, B2 is 177. Please help, how can
I write a formula for this.
 

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

VBA Coding Help for Beginner 0
Excel - Wich Function should I use? 1
% Difference between cells based on variable... 6
If Condition 0
Set date minuse 1 working day 3
Formulas Still Not Working 5
If Condition 4
Count the remaining weekdays in a data range excluding holidays and start/end dates 5

Top