Question:

Excel formula question

by  |  earlier

0 LIKES UnLike

I have a total of pounds sold, and 4 ranges to pick from if it equals the criteris. i.e., If the pounds are below 1 #, it equals 0, if lbs are between 2 #'s it equals 40, if lbs are between 2 other #'s it equals 150, and if lbs are greater than the highest #, it equals 200.

I've tried IF statements, and can get the first condition to work, however, when I add another, it errors with #value.

What formula do I need use?

 Tags:

   Report
Please Login to view 1 answers to this question
You're reading: Excel formula question

Question Stats

Latest activity: earlier.
This question has 1 answers.

BECOME A GUIDE

Share your knowledge and help people by answering questions.