< and > functions aren"t working for me
 

I am trying to create a fomula that will give me the following results.
1st fomula cell K18 - If h18 is greater than 70 but less than 100 x it by .19
2nd fomula cell L18 - If h18 is greater than 100 but less than 300 x it by
..14
3rd fomular cell M 18 - If h18 is greater than 300 then x it by .12
I have tried H18<70100*.19. It enters the results regardless of the figure
in cell 18. Please help!!!!!!!!!! Thanks

Hi!

Just a few points to consider.

You can do all of those calculations with just a single
formula in a single cell if you wanted.

You don't define what to do if H18 is <=70,=100,=300.

Biff

-----Original Message-----
I am trying to create a fomula that will give me the
following results.
1st fomula cell K18 - If h18 is greater than 70 but less
than 100 x it by .19
2nd fomula cell L18 - If h18 is greater than 100 but
less than 300 x it by
..14
3rd fomular cell M 18 - If h18 is greater than 300 then
x it by .12
I have tried H18<70100*.19. It enters the results
regardless of the figure
in cell 18. Please help!!!!!!!!!! Thanks
.

Try something like ..

In K18: =IF(AND(H1870,H18<=100),H18*0.19,"")
In L18: =IF(AND(H18100,H18<=300),H18*0.14,"")
In M18: =IF(H18300,H18*0.12,"")

Above assumes that blanks: ""
are to be returned if the criteria is not met
(the value_if_false)

Also, assumptions to plug the gaps in the specs,
(value in H18 equal to either: 100, 300)
have also been made (adjust to suit if incorrect)
--
Rgds
Max
xl 97
---
Please respond in thread
xdemechanik <atyahoo<dotcom
----
"Dock Buddy" <Dock wrote in message
...
I am trying to create a fomula that will give me the following results.
1st fomula cell K18 - If h18 is greater than 70 but less than 100 x it by
..19
2nd fomula cell L18 - If h18 is greater than 100 but less than 300 x it
by
.14
3rd fomular cell M 18 - If h18 is greater than 300 then x it by .12
I have tried H18<70100*.19. It enters the results regardless of the
figure
in cell 18. Please help!!!!!!!!!! Thanks

Dock Buddy Wrote:
I am trying to create a fomula that will give me the following results.
1st fomula cell K18 - If h18 is greater than 70 but less than 100 x it
by .19
2nd fomula cell L18 - If h18 is greater than 100 but less than 300 x
it by
..14
3rd fomular cell M 18 - If h18 is greater than 300 then x it by .12
I have tried H18<70100*.19. It enters the results regardless of the
figure
in cell 18. Please help!!!!!!!!!! Thanks

In cell K18 =if(and(h1870,h18<100),h18*0.19,"")

In Cell L18 =if(and(h18100,h18<300),h18*0.14,"")

In Cell M18 =if(h18300,h18*.0.12,"")


COMMENTS:

1. You can have one formula to satisfy all your given conditions.

2. Just curious, what happens during the following conditions?:

h18<=70
h18=100
h18=300


--
BenjieLop


------------------------------------------------------------------------
BenjieLop's Profile: http://www.excelforum.com/member.php...o&userid=11019
View this thread: http://www.excelforum.com/showthread...hreadid=275149

Hi

P.e. with rules
H18<70 - 0
H18=70 and H18<100 - 0.18
H18=100 and H18<300 - 0.14
H18=300 - 0.12

a single formula for your task will be:
=CHOOSE(MATCH(H218{0,70,100,300},1),0,0.19,0.14,0. 12)
When you want for H18<70 an empty cell returned, then
=CHOOSE(MATCH(H218{0,70,100,300},1),"",0.19,0.14,0 .12)


--
Arvi Laanemets
(When sending e-mail, use address arvil<Attarkon.ee)


"Dock Buddy" <Dock wrote in message
...
I am trying to create a fomula that will give me the following results.
1st fomula cell K18 - If h18 is greater than 70 but less than 100 x it by
..19
2nd fomula cell L18 - If h18 is greater than 100 but less than 300 x it
by
.14
3rd fomular cell M 18 - If h18 is greater than 300 then x it by .12
I have tried H18<70100*.19. It enters the results regardless of the
figure
in cell 18. Please help!!!!!!!!!! Thanks

hi,
You may use the clipboard from the edit menu.select the cell containing
ABCDEF. Select the required portion ' AB' on the function tab ,click edit
menu, click copy .By this AB is copied to the clipboard.Similarly the portios
C and DEF can also be selected and copied to the clipboard (maximum 12
values/texts) .Then select the cell in which you want AB to be shown.Please
click the required item from the clipboard.Similarly, do this for other
values also.
K.S.Warrier

"Dock Buddy" wrote:

I am trying to create a fomula that will give me the following results.
1st fomula cell K18 - If h18 is greater than 70 but less than 100 x it by .19
2nd fomula cell L18 - If h18 is greater than 100 but less than 300 x it by
.14
3rd fomular cell M 18 - If h18 is greater than 300 then x it by .12
I have tried H18<70100*.19. It enters the results regardless of the figure
in cell 18. Please help!!!!!!!!!! Thanks

Sorry,
This is an answer to another question.
K.S.Warrier

"K.S.Warrier" wrote:

hi,
You may use the clipboard from the edit menu.select the cell containing
ABCDEF. Select the required portion ' AB' on the function tab ,click edit
menu, click copy .By this AB is copied to the clipboard.Similarly the portios
C and DEF can also be selected and copied to the clipboard (maximum 12
values/texts) .Then select the cell in which you want AB to be shown.Please
click the required item from the clipboard.Similarly, do this for other
values also.
K.S.Warrier

"Dock Buddy" wrote:

I am trying to create a fomula that will give me the following results.
1st fomula cell K18 - If h18 is greater than 70 but less than 100 x it by .19
2nd fomula cell L18 - If h18 is greater than 100 but less than 300 x it by
.14
3rd fomular cell M 18 - If h18 is greater than 300 then x it by .12
I have tried H18<70100*.19. It enters the results regardless of the figure
in cell 18. Please help!!!!!!!!!! Thanks