Help with conditional formula...

  • Thread starter Thread starter ephedralover
  • Start date Start date
E

ephedralover

I need some help with a conditional formula. Here is my fomula now.
=IF(B3=3,C8*3.75). The cell B3 can have either 3, 4, 5 or 6 as the
value. How can I adjust how much C8 is multiplied by depending on
whether B3 has a 3-6 value? Or in other words, how can I attach
another condition onto this formula? Thanks.
 
=if(B3=3,C8*[condition1],IF(B3=4,C8*[condition2],IF(B3=5,C8*[condition3],C8*[condition4])))

Dave
 
=if(B3=3,C8*[condition1],IF(B3=4,C8*[condition2],IF(B3=5,C8*[condition3],C8*[condition4])))

Dave
--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.

[email protected] said:
I need some help with a conditional formula. Here is my fomula now.
=IF(B3=3,C8*3.75). The cell B3 can have either 3, 4, 5 or 6 as the
value. How can I adjust how much C8 is multiplied by depending on
whether B3 has a 3-6 value? Or in other words, how can I attach
another condition onto this formula? Thanks.
Click to expand...
Click to expand...


Thats it. Thanks Dave!
 

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

LOOKUP/IF Formula Help!! 1
If OR formula 1
Conditional formating 1
SUM formula after HLOOKUP result true 9
Comparison of columns using Conditional Formatting 3
sumproduct formula on steroids 11
How to use autofilter in excel with formula reference changing 1
IF(AND(OR function returns #VALUE! error 3

Back
Top