Hi.
I have an problem with an if function. I have to get excel to understand that if attendance rises above cell G26 then the pay for the guards will be I26 and if the attendence is in between G27 and H27 then the pay for the guards will be I27 and if the attendance is below or equal to cell G28 then the pay for the guards must be I28.
Can someone please help?!
Hi Pede,
Please upload a sample file along with your expected results.. thanks.
Regards,
DILIPandey
<click on below * if this helps>
DILIPandey, Excel rMVP
+919810929744 (India), +971528225509 (Dubai), dilipandey@gmail.com
Perhaps something like this?
=IF(B5>G26;I26;IF(AND(B5>G27;B5<H27);I27;I28))
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.
Mappe1.xlsx This should be it
Fotis, it wasn't quite right, but close and I figured it out thanks to your formula
..................
Hi Pede, that is great you figured out formula but please share that formula in this thread as well as that may help other users who lands up here via internet search.
Also, mark this thread as [SOLVED]... thanks.
Regards,
DILIPandey
<click on below * if this helps>
=if(B5>=$I$26;$K$26;if(and(B5<$I$27;B5>$J$27);$K$27;$K$28)) I'm new here, where should I mark the thread as closed?
Go to your first post in this thread, and on the top right of your the first post, choose 'Thread Tools' and there is where you can mark this tread as solved.
Should all be done now. Thanks for the help everybody!
HI pede,
below is what I got from forum rules:-
If your problem is solved, please say so clearly, and mark your thread as Solved: Click Thread Tools above your first post, select "Mark your thread as Solved". Or click the Edit button on your first post in the thread, Click Go Advanced, select [SOLVED] from the Prefix dropdown, then click Save Changes. If more than two days have elapsed, the Dropdown option or Edit button will not appear -- ask a moderator to mark it.
http://www.excelforum.com/forum-rule...rum-rules.html
Regards,
DILIPandey
<click on below * if this helps>
Already done. But thanks for the tip. Problem solved!
you are welcome pede..
cheers
Regards,
DILIPandey
<click on below * if this helps>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks