Multiple IF in one cell

[hyewiz]

Hello, Please if someone can help me with multiple IF formula,

I am preparing a sheet which has U.S and Canadian cost price what I would like is on E7 to calculate jobber price from my cost on "F" based on
value from Q3,Q4,Q5 then add the exchange rate P3 and calculate the Margin of profit based and O3,O4,O5

And same time E7 must also check "G" and if there is a value should calculate same way as above except not to add the exchange rate P3.

I know this is not making any sense that's why I have attached a sample of what I needed. I hope that helps.

[Glenn Kennedy]

???

In E7, copied down:

=IF(SUM(F7:G7)=0,"",LOOKUP(SUM(F7:G7),$Q$3:$Q$5,$O$3:$O$5)*SUM(F7:G7)*IF(F7>0,P3,1))

Also, please amend your profile to show which version of Excel you are using. Are you really still using Excel 2003 or earlier??? If not, why are you using the obsolete .xls format?

[Glenn Kennedy]

Just noticed an error:

=IF(SUM(F7:G7)=0,"",LOOKUP(SUM(F7:G7),$Q$3:$Q$5,$O$3:$O$5)*SUM(F7:G7)*IF(F7>0,$P$3,1))

[hyewiz]

Thank you for your fast reply, at work we use 365, and at home 2016, but sorry somehow it just saved as .xls

[hyewiz]

Thank you thank you this is what I wanted, just one small problem can we add to this another value from $1001.00 and on rate 1.10


Please

[Glenn Kennedy]

Is this it??

if so... You're welcome. If not, what's wrong & I'll fix it (with a bit of luck!!).

---

If that takes care of your original question, please select "Thread Tools" from the menu link above and mark this thread as SOLVED.

It'd also be appreciated if you were to click the Add Reputation button at the foot of any of the posts of all members who helped you reach a solution.

[hyewiz]

Thank you very much its what I needed,

[Glenn Kennedy]

You're welcome and thanks for the Rep.