Needing help with IF, AND Function?
I am trying to use multiple formulas to come to a final outcome. The final formula is fighting back.
In words:
if g7 is >0 and <=30... i7 will be the number 1000
if g7 is >30 and <=60... i7 will be the number 1900
if g7 is >60 and <=90... i7 will be the number 2900
if g7 is >90 and <=120... i7 will be the number 3900
if g7 is >120 and <=150... i7 will be the number 4900
if g7 is >150 and <=180... i7 will be the number 5900
if g7 is >180 and <=210... i7 will be the number 6900
if g7 is >210 and <=240... i7 will be the number 7900
if g7 is >240 and <=270... i7 will be the number 8900
if g7 is >270 and <=300... i7 will be the number 9900
When I try and put all this into one formula, I seem to have an error somewhere. Do I need to use another type of functions? Please help.
Last edited by jbolinger; 09-01-2011 at 11:57 AM. Reason: ask for other functions to use
Thank you for your time,
Jimmy Bolinger
Will this work?
=IF(G7<=30,1000,INT((G7-1)/30)*1000+900)
Microsoft MVP - Excel
Where there is a will there are many ways. Pick One!
Please read the Forum Rules
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
Preferred Charities: Lupus Canada and Sick Kids Foundation.
Feel Free to Donate if you want to, for the assistance you received today.
Try
=IF(G7<=0,"",INDEX({990,8900,7900,6900,5900,4900,,3900,2900,1900,1000},match(g7,{300,270,240,210,180 ,1560,120,90,60,30},-1))
Worked Great!
Thank you for your time,
Jimmy Bolinger
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks