M
Master T
=If( statement for 80-90% condition then write "ME"
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
D
Dave
Hi,
Something like:
=IF(AND(A1>=80%,A1<=90%),"ME","")
Regards - Dave.
Something like:
=IF(AND(A1>=80%,A1<=90%),"ME","")
Regards - Dave.
J
Jarek Kujawa
thks for yr kind reply...
M
MartinW
Maybe
=IF(AND(A1>80%,A1<90%),"ME","")
or
=IF(AND(A1>=80%,A1<=90%),"ME","")
If they are no good then you will have to explain
in a (lot) more detail.
HTH
Martin
=IF(AND(A1>80%,A1<90%),"ME","")
or
=IF(AND(A1>=80%,A1<=90%),"ME","")
If they are no good then you will have to explain
in a (lot) more detail.
HTH
Martin
D
Dave
You're welcome
M
Master T
HI
Thanks very much, this was really helpful
Thanks very much, this was really helpful
Dave said:Hi,
Something like:
=IF(AND(A1>=80%,A1<=90%),"ME","")
Regards - Dave.
J
Jarek Kujawa
Dave, I was "answering" the OP
;-)
;-)