=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.


" wrote:

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.