Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
need formula help
I'm trying to have a formula do 3 scenerios in one cell and have a partial
formula working: IF(AND(G3930, G39<=7),3000) which equates to if cell G39 is greater than 0 and less than or equal to 7 use 3000. I would like to continue the formula that if G39 is greater than 7 and less than 14 use 5000 and if G39 is greater than 14 use 7500. How can I do this? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
need formula help
Hi,
=IF(AND(G390, G39<=7),3000,IF(AND(G397, G39<=14),5000,if(G3914,7500))) "tom" wrote: I'm trying to have a formula do 3 scenerios in one cell and have a partial formula working: IF(AND(G3930, G39<=7),3000) which equates to if cell G39 is greater than 0 and less than or equal to 7 use 3000. I would like to continue the formula that if G39 is greater than 7 and less than 14 use 5000 and if G39 is greater than 14 use 7500. How can I do this? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
need formula help
=IF(AND(G3930,G39<=7),3000,IF(AND(G397,G39<14),5 000,IF(G3914,7500,0)
care to what is more important to you.. 1st items will cancel later items, even if they are also true. you can change the order in which they occur. "tom" wrote: I'm trying to have a formula do 3 scenerios in one cell and have a partial formula working: IF(AND(G3930, G39<=7),3000) which equates to if cell G39 is greater than 0 and less than or equal to 7 use 3000. I would like to continue the formula that if G39 is greater than 7 and less than 14 use 5000 and if G39 is greater than 14 use 7500. How can I do this? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
need formula help
IF(G39<=0, "", IF(G39<=7,3000, IF(G39<14,5000, IF(G3914,7500,"G39 is equal
to 14")))) -- David Biddulph tom wrote: I'm trying to have a formula do 3 scenerios in one cell and have a partial formula working: IF(AND(G3930, G39<=7),3000) which equates to if cell G39 is greater than 0 and less than or equal to 7 use 3000. I would like to continue the formula that if G39 is greater than 7 and less than 14 use 5000 and if G39 is greater than 14 use 7500. How can I do this? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
need formula help
thank you!
"Eduardo" wrote: Hi, =IF(AND(G390, G39<=7),3000,IF(AND(G397, G39<=14),5000,if(G3914,7500))) "tom" wrote: I'm trying to have a formula do 3 scenerios in one cell and have a partial formula working: IF(AND(G3930, G39<=7),3000) which equates to if cell G39 is greater than 0 and less than or equal to 7 use 3000. I would like to continue the formula that if G39 is greater than 7 and less than 14 use 5000 and if G39 is greater than 14 use 7500. How can I do this? |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
need formula help
correction on formula, needs 2 more parenthesis
=IF(AND(G3930,G39<=7),3000,IF(AND(G397,G39<14),5 000,IF(G3914,7500,0))) "Dan" wrote: =IF(AND(G3930,G39<=7),3000,IF(AND(G397,G39<14),5 000,IF(G3914,7500,0) care to what is more important to you.. 1st items will cancel later items, even if they are also true. you can change the order in which they occur. "tom" wrote: I'm trying to have a formula do 3 scenerios in one cell and have a partial formula working: IF(AND(G3930, G39<=7),3000) which equates to if cell G39 is greater than 0 and less than or equal to 7 use 3000. I would like to continue the formula that if G39 is greater than 7 and less than 14 use 5000 and if G39 is greater than 14 use 7500. How can I do this? |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
need formula help
Maybe a bit shorter
=LOOKUP(G39,{0,8,15},{3000,5000,7500}) -- Mike When competing hypotheses are otherwise equal, adopt the hypothesis that introduces the fewest assumptions while still sufficiently answering the question. "tom" wrote: I'm trying to have a formula do 3 scenerios in one cell and have a partial formula working: IF(AND(G3930, G39<=7),3000) which equates to if cell G39 is greater than 0 and less than or equal to 7 use 3000. I would like to continue the formula that if G39 is greater than 7 and less than 14 use 5000 and if G39 is greater than 14 use 7500. How can I do this? |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
need formula help
Does this segment make sense: AND(G3930,G39<=7),... ?
Micky "Dan" wrote: correction on formula, needs 2 more parenthesis =IF(AND(G3930,G39<=7),3000,IF(AND(G397,G39<14),5 000,IF(G3914,7500,0))) "Dan" wrote: =IF(AND(G3930,G39<=7),3000,IF(AND(G397,G39<14),5 000,IF(G3914,7500,0) care to what is more important to you.. 1st items will cancel later items, even if they are also true. you can change the order in which they occur. "tom" wrote: I'm trying to have a formula do 3 scenerios in one cell and have a partial formula working: IF(AND(G3930, G39<=7),3000) which equates to if cell G39 is greater than 0 and less than or equal to 7 use 3000. I would like to continue the formula that if G39 is greater than 7 and less than 14 use 5000 and if G39 is greater than 14 use 7500. How can I do this? |
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
need formula help
The 30 is a typo. If you look at the OP you'll see that it refers to zero.
-- David Biddulph ????? (????) ????? wrote: Does this segment make sense: AND(G3930,G39<=7),... ? Micky "Dan" wrote: correction on formula, needs 2 more parenthesis =IF(AND(G3930,G39<=7),3000,IF(AND(G397,G39<14),5 000,IF(G3914,7500,0))) "Dan" wrote: =IF(AND(G3930,G39<=7),3000,IF(AND(G397,G39<14),5 000,IF(G3914,7500,0) care to what is more important to you.. 1st items will cancel later items, even if they are also true. you can change the order in which they occur. "tom" wrote: I'm trying to have a formula do 3 scenerios in one cell and have a partial formula working: IF(AND(G3930, G39<=7),3000) which equates to if cell G39 is greater than 0 and less than or equal to 7 use 3000. I would like to continue the formula that if G39 is greater than 7 and less than 14 use 5000 and if G39 is greater than 14 use 7500. How can I do this? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|