# Multiple IF in one cell

1. ## Multiple IF in one cell

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.

2. ## Re: Multiple IF in one cell

???

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?

3. ## Re: Multiple IF in one cell

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))

4. ## Re: Multiple IF in one cell

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

5. ## Re: Multiple IF in one cell

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

6. ## Re: Multiple IF in one cell

Is this it??

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

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.

7. ## Re: Multiple IF in one cell

Thank you very much its what I needed,

8. ## Re: Multiple IF in one cell

You're welcome and thanks for the Rep.

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1