Multiple IF formula with cell references

S

selinaag

New Member
Joined
Feb 2, 2012
Messages
19
Please help - I am desperate... can Excel do a double if formula by looking at cells and not fixed type info.


EG: I have a % achieved and $ bonus to pay: however the % achieved & the $ bonus to pay information in the cell will change each month


So... I want the formula to say
=IF (look for cell A1 (which has %achieved) and if found use A2 ($bonus) to give me an answer... otherwise false

The second dillema I have is that A1 has 3 ranges from 100-150, 150-200 & 200-300 to calculate with a set % in A2


Is this possible? :(
 
Sort by date Sort by votes
Hi Adam - I had a screen print, however i cannot get input it as it only wants a http:// option... and so does the hyperlink :rolleyes:
 
Upvote 0
There are some options in my signature. Problem with a screen shot is that we can't copy and paste the data in to Excel to play with :)

Regards
Adam
 
Upvote 0
Hi Adam...

The html thing is just not working for me... I get tons of html jargon pasted but no picture to paste... the whole file needs to be reviewd to get the picture so I will try emailing a friend tommrrow.. it's been a long day - it's late here in Oz & I have given up for the night. I'll try work on it again tommorrow.
Thanks for your help anyway.:)
 
Upvote 0
selinaag said:
Please help - I am desperate... can Excel do a double if formula by looking at cells and not fixed type info.


EG: I have a % achieved and $ bonus to pay: however the % achieved & the $ bonus to pay information in the cell will change each month


So... I want the formula to say
=IF (look for cell A1 (which has %achieved) and if found use A2 ($bonus) to give me an answer... otherwise false

The second dillema I have is that A1 has 3 ranges from 100-150, 150-200 & 200-300 to calculate with a set % in A2


Is this possible? :(
Click to expand...

Can you split your A1 int three diffrent cell and then try to use lookup?
 
Upvote 0
Re: NESTED IF formula with multiple conditions

I think the solustion is a NESTED IF formula with multiple conditions - can anymone help with:

eg: the following 4 arguments in 1 complete formula:
IF <84850 = $0 (or "no bonus")
IF between 84850 & 93037.99 = $100.00
IF between 93038 & 101495.99 = $150.00
IF = > 101496 = $200.00

The second formula I have to do has 5 arguments:
IF <90% = -25% from A1
IF between 90% & 99.99% = 0% (or "no bonus")
IF between 100% & 109.99% = 10% of A1
IF between 110% & 121.99% = 15% of A1
IF = > 122% = 20% of A1

HELP!
 
Upvote 0
Re: NESTED IF formula with multiple conditions

selinaag said:
I think the solustion is a NESTED IF formula with multiple conditions - can anymone help with:

eg: the following 4 arguments in 1 complete formula:
IF <84850 = $0 (or "no bonus")
IF between 84850 & 93037.99 = $100.00
IF between 93038 & 101495.99 = $150.00
IF = > 101496 = $200.00

The second formula I have to do has 5 arguments:
IF <90% = -25% from A1
IF between 90% & 99.99% = 0% (or "no bonus")
IF between 100% & 109.99% = 10% of A1
IF between 110% & 121.99% = 15% of A1
IF = > 122% = 20% of A1

HELP!
Click to expand...

Do you have a twin brother/sister?

http://www.mrexcel.com/forum/showthread.php?t=620466
 
Upvote 0
I have a log in at work and a log in at home... so still looking for the answer to the NESTED IF formula on both sides :-)
 
Upvote 0
You must log in or register to reply here.

Similar threads

J
  • Solved
Replace multiple specific pieces of text in a cell
Replies
3
Views
372
Joe4
Joe4
D
  • Question Question
Formula references changing when adding a row to a table.
2
Replies
10
Views
399
Peter_SSs
Peter_SSs
A
  • Question Question
Evaluate cell or have cell refer to itself after being transposed via. lookup functions
Replies
2
Views
160
Sam_D_Ben
Sam_D_Ben
S
  • Solved
VBA Help - unless something else works
2
Replies
17
Views
731
Joe4
Joe4
M
  • Solved
XLOOKUP & SEQUENCE in Dynamic Array
Replies
9
Views
1K
Fluff
Fluff

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top