I am trying to create an if function I believe.....I have a cell--I58 where I want this function. If the number that is in cell I57 is greater than or equal to 6500-16,249, then I want I57*.03. If the number that is in cell I57 is greater than 16,250, then I want I57*.06.
can you please help me write this function? Thanks!
Maybe something like this:
=If(I57>=6500,If(I57<=16,249,I57*0.03,I57*0.06),"Number less than 6500")
Please consider:
Thanking those who helped you. Click the star icon in the lower left part of the contributor's post and add Reputation.
Cleaning up when you're done. Mark your thread [SOLVED] if you received your answer.
Hi
Something like this?
=IF(I57=16249,(I57*0,3),IF(I57=16250,(I57*0,6),""))
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
Well, something is wrong....I can't get either of these to work....it keeps coming up as an error....
Jo
Hi joann,
You can try this formula =IF(AND(I57>6499,I57<=16249),I57*0.03,IF(I57>16250,I57*0.06,0)) but because you don't state what happens if I57 is less than 6500, I had the cell multiplied by 0. Hope this helps
Dawn - Guru in Training
Thank you so much!! Worked perfect!!
Jo
Well, Jo.....
Admin, asked something from you.
Do this and then we'll find your solution......
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks