I am hoping to get help with a formula please. What I have so far is working but I have decided to add to it.
=IF(AI16>809,2IF(AND(AI16<809,ai16>=404.5),1,0-A-AA-AI17-AI14-AI13)
I need to expand the formula by adding in that if the cell = 202.25 then it would be .5, if the cell =606.75 then it would be 1.5.
For whatever reason I just can't see the leaves for the trees today and figure out how to fix the formula to include my additions. Basically this is what it is supposed to be:
809 = 2
606.75 = 1.5
404.5 = 1
202.25 = .5
Can anyone help?
Fix1
----------------
Play with this formula
If(AI16>=809,2,if(AI16>=606.75,1.5,IF(AI16>=404.5,1,IF(AI16>=202.25,.5,"??" ))))
Good Luck Post back with any problems
Fix2
-------------------
I would recommend using a LOOKUP formula instead, which would mean you would have to create your table separately. But you could add to it or change it any time you wanted, which would then update all formulas pointing to it. I generally find that far simpler than nesting a bunch of IF() functions. Post back if you need more help (and if you do, please clarify your formula, it doesn't make sense.)
Fix3
-------------------
I have a spreadsheet tracking extra hours worked, sick days, flex days, etc. However flex days are not accrued when a vacation day is taken or sick day or a stat holiday happens. All of these "arguments" require explanation within the formula. Also, it takes 9 days work 45mins extra/day to earn 1 flex day. And so on. Hence the original example.
809 = 2
606.75 = 1.5
404.5 = 1
202.25 = .5
I have included an example spreadsheet to show you so that perhaps you can assist with a better formula that will work????????
Fix4
-----------------------
My apologies, as I lost my way on the site when I tried to close the thread as you name it. Then on the weekend when I was working on it myself, I could not remember my password that I set. Because I can't access my work email from home, I just set up another user so that I could continue my work. Of course, my inexperience led to me thinking I posted my question on Saturday and in actuality, it never did post. I posted it this morning when I noticed that I had done something wrong.
There was no malice intended, nor did I want to offend you, as it seems that you feel that way. You helped me immensely and that is why I returned to the site.
I don't frequent sites like this so I apologize for not being "savvy" in the ways of the internet or the protocol required.
If nobody feels that they can assist me further then I will attempt to find the assistance that I need, elsewhere.
=IF(AI16>809,2IF(AND(AI16<809,ai16>=404.5),1,0-A-AA-AI17-AI14-AI13)
I need to expand the formula by adding in that if the cell = 202.25 then it would be .5, if the cell =606.75 then it would be 1.5.
For whatever reason I just can't see the leaves for the trees today and figure out how to fix the formula to include my additions. Basically this is what it is supposed to be:
809 = 2
606.75 = 1.5
404.5 = 1
202.25 = .5
Can anyone help?
Fix1
----------------
Play with this formula
If(AI16>=809,2,if(AI16>=606.75,1.5,IF(AI16>=404.5,1,IF(AI16>=202.25,.5,"??" ))))
Good Luck Post back with any problems
Fix2
-------------------
I would recommend using a LOOKUP formula instead, which would mean you would have to create your table separately. But you could add to it or change it any time you wanted, which would then update all formulas pointing to it. I generally find that far simpler than nesting a bunch of IF() functions. Post back if you need more help (and if you do, please clarify your formula, it doesn't make sense.)
Fix3
-------------------
I have a spreadsheet tracking extra hours worked, sick days, flex days, etc. However flex days are not accrued when a vacation day is taken or sick day or a stat holiday happens. All of these "arguments" require explanation within the formula. Also, it takes 9 days work 45mins extra/day to earn 1 flex day. And so on. Hence the original example.
809 = 2
606.75 = 1.5
404.5 = 1
202.25 = .5
I have included an example spreadsheet to show you so that perhaps you can assist with a better formula that will work????????
Fix4
-----------------------
My apologies, as I lost my way on the site when I tried to close the thread as you name it. Then on the weekend when I was working on it myself, I could not remember my password that I set. Because I can't access my work email from home, I just set up another user so that I could continue my work. Of course, my inexperience led to me thinking I posted my question on Saturday and in actuality, it never did post. I posted it this morning when I noticed that I had done something wrong.
There was no malice intended, nor did I want to offend you, as it seems that you feel that way. You helped me immensely and that is why I returned to the site.
I don't frequent sites like this so I apologize for not being "savvy" in the ways of the internet or the protocol required.
If nobody feels that they can assist me further then I will attempt to find the assistance that I need, elsewhere.
Hiç yorum yok:
Yorum Gönder