ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   =If( statement for 80-90% condition then write "ME" (https://www.excelbanter.com/excel-worksheet-functions/195383-%3Dif-statement-80-90%25-condition-then-write-me.html)

Master T

=If( statement for 80-90% condition then write "ME"
 
=If( statement for 80-90% condition then write "ME"

Dave

=If( statement for 80-90% condition then write "ME"
 
Hi,
Something like:
=IF(AND(A1=80%,A1<=90%),"ME","")
Regards - Dave.

"Master T" wrote:

=If( statement for 80-90% condition then write "ME"


Jarek Kujawa[_2_]

=If( statement for 80-90% condition then write "ME"
 
thks for yr kind reply...

MartinW[_2_]

=If( statement for 80-90% condition then write "ME"
 
Maybe
=IF(AND(A180%,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


"Master T" <Master wrote in message
...
=If( statement for 80-90% condition then write "ME"




Dave

=If( statement for 80-90% condition then write "ME"
 
You're welcome

Master T[_2_]

=If( statement for 80-90% condition then write "ME"
 
HI

Thanks very much, this was really helpful

"Dave" wrote:

Hi,
Something like:
=IF(AND(A1=80%,A1<=90%),"ME","")
Regards - Dave.

"Master T" wrote:

=If( statement for 80-90% condition then write "ME"


Jarek Kujawa[_2_]

=If( statement for 80-90% condition then write "ME"
 
Dave, I was "answering" the OP
;-)


All times are GMT +1. The time now is 04:10 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com