Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel IF Formula for an inventory...
Please, I need help with a formula,
I'm looking for a formula (Something like the IF formula) that will allow me to show three(3) different text expressions in one cell according to mathmatic range. Currently, the only one I can figure out is: =IF(K25I25,"Inventory above range","Inventory within range"). I have tried the =IF(AND.... & =IF(OR... formulas. I would like for the cell to have the ability to report: "Inventory above range", "Inventory within range" & "Inventory below range". |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel IF Formula for an inventory...
=IF(K25I25,"Inventory above range",IF(K25<J25,"Inventory below
range","Inventory within range")) -- David Biddulph "Allan Grates" <Allan wrote in message ... Please, I need help with a formula, I'm looking for a formula (Something like the IF formula) that will allow me to show three(3) different text expressions in one cell according to mathmatic range. Currently, the only one I can figure out is: =IF(K25I25,"Inventory above range","Inventory within range"). I have tried the =IF(AND.... & =IF(OR... formulas. I would like for the cell to have the ability to report: "Inventory above range", "Inventory within range" & "Inventory below range". |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel IF Formula for an inventory...
You need a third cell to tell you when the inventory is below range.
-- Gary''s Student - gsnu200810 "Allan Grates" wrote: Please, I need help with a formula, I'm looking for a formula (Something like the IF formula) that will allow me to show three(3) different text expressions in one cell according to mathmatic range. Currently, the only one I can figure out is: =IF(K25I25,"Inventory above range","Inventory within range"). I have tried the =IF(AND.... & =IF(OR... formulas. I would like for the cell to have the ability to report: "Inventory above range", "Inventory within range" & "Inventory below range". |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel IF Formula for an inventory...
Hi Allan ! :) The formula you need is something like this. =IF(K25I25,"Above Range",IF(AND(K25<=I25,K25=I24),"Within Range","Below Range")) Note: The cell I24 contains the lower limit of the inventory range. I hope you find the info useful ! Good Luck ! Vijay "Allan Grates" wrote: Please, I need help with a formula, I'm looking for a formula (Something like the IF formula) that will allow me to show three(3) different text expressions in one cell according to mathmatic range. Currently, the only one I can figure out is: =IF(K25I25,"Inventory above range","Inventory within range"). I have tried the =IF(AND.... & =IF(OR... formulas. I would like for the cell to have the ability to report: "Inventory above range", "Inventory within range" & "Inventory below range". |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel IF Formula for an inventory...
You don't need the K25<=I25 test, Vijay, as you've already dealt with the
K25I25 cases. -- David Biddulph "Vijay Chary" wrote in message ... Hi Allan ! :) The formula you need is something like this. =IF(K25I25,"Above Range",IF(AND(K25<=I25,K25=I24),"Within Range","Below Range")) Note: The cell I24 contains the lower limit of the inventory range. I hope you find the info useful ! Good Luck ! Vijay "Allan Grates" wrote: Please, I need help with a formula, I'm looking for a formula (Something like the IF formula) that will allow me to show three(3) different text expressions in one cell according to mathmatic range. Currently, the only one I can figure out is: =IF(K25I25,"Inventory above range","Inventory within range"). I have tried the =IF(AND.... & =IF(OR... formulas. I would like for the cell to have the ability to report: "Inventory above range", "Inventory within range" & "Inventory below range". |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel IF Formula for an inventory...
Hi David !! :)
That's the general idea. If you examine my version of the formula, you'll find it has only two conditions in it; one to test if the given value is above the range and the other to test if the value is within the range. The third condition is obained from the other two as an 'ELSE'. "David Biddulph" wrote: You don't need the K25<=I25 test, Vijay, as you've already dealt with the K25I25 cases. -- David Biddulph "Vijay Chary" wrote in message ... Hi Allan ! :) The formula you need is something like this. =IF(K25I25,"Above Range",IF(AND(K25<=I25,K25=I24),"Within Range","Below Range")) Note: The cell I24 contains the lower limit of the inventory range. I hope you find the info useful ! Good Luck ! Vijay "Allan Grates" wrote: Please, I need help with a formula, I'm looking for a formula (Something like the IF formula) that will allow me to show three(3) different text expressions in one cell according to mathmatic range. Currently, the only one I can figure out is: =IF(K25I25,"Inventory above range","Inventory within range"). I have tried the =IF(AND.... & =IF(OR... formulas. I would like for the cell to have the ability to report: "Inventory above range", "Inventory within range" & "Inventory below range". |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel IF Formula for an inventory...
Yes, Vijay, so instead of your
=IF(K25I25,"Above Range",IF(AND(K25<=I25,K25=I24),"Within Range","Below Range")) all you need is =IF(K25I25,"Above Range",IF(K25=I24,"Within Range","Below Range")) or otherwise the formula I had suggested earlier in the day =IF(K25I25,"Inventory above range",IF(K25<J25,"Inventory below range","Inventory within range")) -- David Biddulph "Vijay Chary" wrote in message ... Hi David !! :) That's the general idea. If you examine my version of the formula, you'll find it has only two conditions in it; one to test if the given value is above the range and the other to test if the value is within the range. The third condition is obained from the other two as an 'ELSE'. "David Biddulph" wrote: You don't need the K25<=I25 test, Vijay, as you've already dealt with the K25I25 cases. -- David Biddulph "Vijay Chary" wrote in message ... Hi Allan ! :) The formula you need is something like this. =IF(K25I25,"Above Range",IF(AND(K25<=I25,K25=I24),"Within Range","Below Range")) Note: The cell I24 contains the lower limit of the inventory range. I hope you find the info useful ! Good Luck ! Vijay "Allan Grates" wrote: Please, I need help with a formula, I'm looking for a formula (Something like the IF formula) that will allow me to show three(3) different text expressions in one cell according to mathmatic range. Currently, the only one I can figure out is: =IF(K25I25,"Inventory above range","Inventory within range"). I have tried the =IF(AND.... & =IF(OR... formulas. I would like for the cell to have the ability to report: "Inventory above range", "Inventory within range" & "Inventory below range". |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel IF Formula for an inventory...
=LOOKUP(K25-I25,{-1E+100,0,1},"Inventory "&{"below","within","above"}&" range")
"Allan Grates" wrote: Please, I need help with a formula, I'm looking for a formula (Something like the IF formula) that will allow me to show three(3) different text expressions in one cell according to mathmatic range. Currently, the only one I can figure out is: =IF(K25I25,"Inventory above range","Inventory within range"). I have tried the =IF(AND.... & =IF(OR... formulas. I would like for the cell to have the ability to report: "Inventory above range", "Inventory within range" & "Inventory below range". |
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel IF Formula for an inventory...
Yes, I see your point, David !! :) Thanks a plenty !
Vijay "David Biddulph" wrote: You don't need the K25<=I25 test, Vijay, as you've already dealt with the K25I25 cases. -- David Biddulph "Vijay Chary" wrote in message ... Hi Allan ! :) The formula you need is something like this. =IF(K25I25,"Above Range",IF(AND(K25<=I25,K25=I24),"Within Range","Below Range")) Note: The cell I24 contains the lower limit of the inventory range. I hope you find the info useful ! Good Luck ! Vijay "Allan Grates" wrote: Please, I need help with a formula, I'm looking for a formula (Something like the IF formula) that will allow me to show three(3) different text expressions in one cell according to mathmatic range. Currently, the only one I can figure out is: =IF(K25I25,"Inventory above range","Inventory within range"). I have tried the =IF(AND.... & =IF(OR... formulas. I would like for the cell to have the ability to report: "Inventory above range", "Inventory within range" & "Inventory below range". |
#10
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel IF Formula for an inventory...
Yes, I see your point, David !! :) Thanks a plenty !
"David Biddulph" wrote: You don't need the K25<=I25 test, Vijay, as you've already dealt with the K25I25 cases. -- David Biddulph "Vijay Chary" wrote in message ... Hi Allan ! :) The formula you need is something like this. =IF(K25I25,"Above Range",IF(AND(K25<=I25,K25=I24),"Within Range","Below Range")) Note: The cell I24 contains the lower limit of the inventory range. I hope you find the info useful ! Good Luck ! Vijay "Allan Grates" wrote: Please, I need help with a formula, I'm looking for a formula (Something like the IF formula) that will allow me to show three(3) different text expressions in one cell according to mathmatic range. Currently, the only one I can figure out is: =IF(K25I25,"Inventory above range","Inventory within range"). I have tried the =IF(AND.... & =IF(OR... formulas. I would like for the cell to have the ability to report: "Inventory above range", "Inventory within range" & "Inventory below range". |
#11
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel IF Formula for an inventory...
David & Vijay,
I tried both formulas and they both worked for me. I decided to use david's formula as it was the first I tried and worked the first time I put it in my inventory. Thanks and appreciate it. Kudos, Allan "David Biddulph" wrote: You don't need the K25<=I25 test, Vijay, as you've already dealt with the K25I25 cases. -- David Biddulph "Vijay Chary" wrote in message ... Hi Allan ! :) The formula you need is something like this. =IF(K25I25,"Above Range",IF(AND(K25<=I25,K25=I24),"Within Range","Below Range")) Note: The cell I24 contains the lower limit of the inventory range. I hope you find the info useful ! Good Luck ! Vijay "Allan Grates" wrote: Please, I need help with a formula, I'm looking for a formula (Something like the IF formula) that will allow me to show three(3) different text expressions in one cell according to mathmatic range. Currently, the only one I can figure out is: =IF(K25I25,"Inventory above range","Inventory within range"). I have tried the =IF(AND.... & =IF(OR... formulas. I would like for the cell to have the ability to report: "Inventory above range", "Inventory within range" & "Inventory below range". |
#12
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel IF Formula for an inventory...
Hi,
And yet another way to write it: ="Inventory "&IF(I25<K25,"below",IF(I25K25,"above","within")) &" range" -- Thanks, Shane Devenshire "Allan Grates" wrote: Please, I need help with a formula, I'm looking for a formula (Something like the IF formula) that will allow me to show three(3) different text expressions in one cell according to mathmatic range. Currently, the only one I can figure out is: =IF(K25I25,"Inventory above range","Inventory within range"). I have tried the =IF(AND.... & =IF(OR... formulas. I would like for the cell to have the ability to report: "Inventory above range", "Inventory within range" & "Inventory below range". |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Inventory and sales formula within a workbook. | Setting up and Configuration of Excel | |||
Formula needed for too much inventory | Excel Worksheet Functions | |||
inventory comparison formula?? | Excel Worksheet Functions | |||
Need help with a formula in inventory | Excel Discussion (Misc queries) | |||
How can i get an inventory list that adds and subtracts inventory | Excel Discussion (Misc queries) |