Microsoft Office Forums

Go Back   Microsoft Office Forums > >
Reload this Page If statement, may be? If statement, may be?
Register FAQ

Reply
 
Thread Tools Display Modes
  #1  
Old 03-04-2015, 03:06 AM
Tony Singh Tony Singh is offline If statement, may be? Windows 7 32bit If statement, may be? Office 2013
Novice
If statement, may be? 		 
Join Date: Mar 2015
Posts: 8
Tony Singh is on a distinguished road
Default If statement, may be?
Hi

I have the following in a row.
6.50 6.60 6.70 6.95
In the last cell I want to put in an IF statement to check the entire row
whether there is a value of less than 6.50 and return MW, if not then return
OK.

May be just basic, but cannot get it to work. Any help would be appreciated.



Thanks
Tony
Reply With Quote
  #2  
Old 03-04-2015, 05:22 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline If statement, may be? Windows 7 64bit If statement, may be? Office 2010 64bit
Expert
  
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,948
Pecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond repute
Default
Try = IF(countif(a1:a4,"<="&6.50),"MW","OK")

Adapt the range to your needs
__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
Reply With Quote
  #3  
Old 03-04-2015, 05:53 AM
Tony Singh Tony Singh is offline If statement, may be? Windows 7 32bit If statement, may be? Office 2013
Novice
If statement, may be? 		 
Join Date: Mar 2015
Posts: 8
Tony Singh is on a distinguished road
Default
Hi Pecoflyer

Thanks for your reply.
I did Tried this but it is saying MW to a value of 6.60
-6.60 --MW

Any suggestions, thanks
Reply With Quote
  #4  
Old 03-04-2015, 07:49 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline If statement, may be? Windows 7 64bit If statement, may be? Office 2010 64bit
Expert
  
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,948
Pecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond repute
Default
Please post a sample sheet. It could be that you have some text looking like numbers
__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
Reply With Quote
  #5  
Old 03-04-2015, 08:38 AM
Tony Singh Tony Singh is offline If statement, may be? Windows 7 32bit If statement, may be? Office 2013
Novice
If statement, may be? 		 
Join Date: Mar 2015
Posts: 8
Tony Singh is on a distinguished road
Default
Here we go attached herewith, thanks again.
Attached Files
File Type: xlsx If st 05 03 15.xlsx (8.8 KB, 9 views)
Reply With Quote
  #6  
Old 03-04-2015, 08:43 AM
Tony Singh Tony Singh is offline If statement, may be? Windows 7 32bit If statement, may be? Office 2013
Novice
If statement, may be? 		 
Join Date: Mar 2015
Posts: 8
Tony Singh is on a distinguished road
Default
Pecoflyer, I have just figured it out. It is taking 0 as a value below 6.50, and is why the formula was not working. Just deleted the 0 from celss & it started working fine.

Many thanks for your help, regards, Tony
Reply With Quote
  #7  
Old 03-04-2015, 12:52 PM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline If statement, may be? Windows 7 64bit If statement, may be? Office 2010 64bit
Expert
  
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,948
Pecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond repute
Default
You're welcome
__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
Reply With Quote
Reply

« Previous Thread | Next Thread »


Similar Threads
Thread Thread Starter Forum Replies Last Post
Add a statement sma Word 6 03-23-2014 10:30 AM
If statement, may be? Need help with If, Then Statement Please cangelis Excel 4 01-03-2014 09:10 AM
If statement, may be? Help with IF Statement limpbizkit Excel 4 02-24-2011 09:16 PM
If statement, may be? if statement piper7971 PowerPoint 1 08-19-2010 07:10 AM
If statement, may be? Help with IF statement! CPelkey Word 1 04-12-2010 09:06 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:20 PM.

Contact Us - Privacy Statement - Top

Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft