If statement for different values multiply

rentonhighlands

Board Regular
Joined
Jul 31, 2014
Messages
95
Please help me write a IF statement to do this

If COL X has 10 then multiply by $14.19, if COL X has 20 then multiply by $18.49
I have 8 to sting together. Can a IF statement string 8 different calculations together?
 

Some videos you may like

Excel Facts

Excel motto
Not everything I do at work revolves around Excel. Only the fun parts.

gaz_chops

Well-known Member
Joined
Apr 29, 2003
Messages
6,468
Platform
  1. MacOS
Better to use a lookup, something like

=X2*LOOKUP(X2,{10,20,30,40,50},{14.19,18.49,20,30,40})
 

rentonhighlands

Board Regular
Joined
Jul 31, 2014
Messages
95
I was unclear with my last request for help
I have this formula =LOOKUP(K4,{10,20,30,40,50,100,150,1000,2000},{14.19,18.49,28.38,38.27,63.64,102.52,255.15,255.15})
what I need this formula to do is when in col K4 it finds "10" then populate $14.19, if we find 20 then populate $18.49, if we find 50 then populate $28.38, if we find 150 then populate $63.64.

What is happening now is when it finds "50" it is populating $63.64.
 

Watch MrExcel Video

Forum statistics

Threads
1,108,509
Messages
5,523,317
Members
409,511
Latest member
hitesh222002

This Week's Hot Topics

Top