Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #16  
Old 11-12-2021, 07:48 AM
silverman166 silverman166 is offline Show a list of plants requiring a minimum temperature Windows 10 Show a list of plants requiring a minimum temperature Office 2007
Advanced Beginner
Show a list of plants requiring a minimum temperature
 
Join Date: Nov 2019
Posts: 31
silverman166 is on a distinguished road
Default

Thanks for your explanations, but it still does not work.


Sorry, it seems I omitted to attach the sheet showing my problem in my last post, in which the selected value was not<5, but just 5.




Here it is.


What is going wrong for me?!!


Sounds like I'm also going to have to look into Pivot tables - thanks for the link, and your patience in this problem.
Attached Files
File Type: xlsx Plants Iferror solution.xlsx (8.9 KB, 6 views)
Reply With Quote
  #17  
Old 11-12-2021, 08:09 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Show a list of plants requiring a minimum temperature Windows 7 64bit Show a list of plants requiring a minimum temperature Office 2010
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,766
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default

There is nothing wrong with your sheet, you have to pull cell E3 down, that's all, and the other values will be populated
Reply With Quote
  #18  
Old 11-12-2021, 12:05 PM
silverman166 silverman166 is offline Show a list of plants requiring a minimum temperature Windows 10 Show a list of plants requiring a minimum temperature Office 2007
Advanced Beginner
Show a list of plants requiring a minimum temperature
 
Join Date: Nov 2019
Posts: 31
silverman166 is on a distinguished road
Default

Ah, at last!!

Thankyou.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
minimum charge Trapshooter1956 Excel 2 03-14-2017 09:36 AM
Chart y-axis minimum, auto not working? gebobs Excel 0 03-24-2016 11:05 AM
What are the minimum margins most printers can handle? 20GT Word 3 11-08-2014 10:40 PM
STDEV minimum number of points littlepeaks Excel 0 01-15-2012 06:40 PM
Word Minimum Margin rangeshram Word 0 09-24-2008 01:38 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:24 AM.


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