< and > functions aren"t working for me

[Dock Buddy]

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<70>100*.19. It enters the results regardless of the figure
in cell 18. Please help!!!!!!!!!! Thanks

 

[Biff]

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

 

[Max]

Try something like ..

In K18: =IF(AND(H18>70,H18<=100),H18*0.19,"")
In L18: =IF(AND(H18>100,H18<=300),H18*0.14,"")
In M18: =IF(H18>300,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)

 

[BenjieLop]

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 i
by .19
2nd fomula cell L18 - If h18 is greater than 100 but less than 300
it by
..14
3rd fomular cell M 18 - If h18 is greater than 300 then x it by .12
I have tried H18<70>100*.19. It enters the results regardless of th
figure
in cell 18. Please help!!!!!!!!!! Thanks

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

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

In Cell M18 =if(h18>300,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=30

 

[Arvi Laanemets]

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)

 

[K.S.Warrier]

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

 

[K.S.Warrier]

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