Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default =If( statement for 80-90% condition then write "ME"

=If( statement for 80-90% condition then write "ME"
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1,388
Default =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"

  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 896
Default =If( statement for 80-90% condition then write "ME"

thks for yr kind reply...
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 168
Default =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"



  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1,388
Default =If( statement for 80-90% condition then write "ME"

You're welcome


  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 3
Default =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"

  #7   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 896
Default =If( statement for 80-90% condition then write "ME"

Dave, I was "answering" the OP
;-)
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
is it possitle i write"1"and "one" will show in next coloumn. srksiddiqui Excel Discussion (Misc queries) 1 June 9th 08 02:37 PM
How do I write a conditional "IF" statement to color a group of ce mulehead Excel Discussion (Misc queries) 2 November 8th 07 08:16 PM
embedding "ISERROR" function into an "IF" statement [email protected] Excel Worksheet Functions 8 January 4th 07 12:01 AM
how do I write an "if then" statement in Excel. eg. If L47 = 0 the dxrok Excel Worksheet Functions 1 August 5th 06 10:28 PM
How do I write an 'if exist" statement John in Surrey Excel Worksheet Functions 1 November 1st 05 09:17 PM


All times are GMT +1. The time now is 05:17 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"