 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Worksheet Functions / August 2006formala help required.
The basis of this formula is to work out room size and depending on the area allocate a suitable sized air conditioning unit .... In cells D7 to D10 I will have a figure between 0-45 (sq metres) In cells E7-E10 I require an answer based on D cells if answer between 0-15 then show 9000 if answer between 16-22 then show 12000 if answer between 23-30 then show 18000 if answer 31+ then show 24000 help appreciated for the formula to go into Cells E7-E10 thanks =VLOOKUP(D7,{0,9000;16,12000;23,18000;31,24000},2)  SignatureHTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) > The basis of this formula is to work out room size and depending on the area > allocate a suitable sized air conditioning unit .... [quoted text clipped - 10 lines] > help appreciated for the formula to go into Cells E7-E10 > thanks Excellent! thanks for your speedy and accurate response. > =VLOOKUP(D7,{0,9000;16,12000;23,18000;31,24000},2) > [quoted text clipped - 13 lines] >> help appreciated for the formula to go into Cells E7-E10 >> thanks in E7: =LOOKUP(D7,{0,16,23,31},{9000,12000,18000,24000}) Copy down to E10. HTH > The basis of this formula is to work out room size and depending on the area > allocate a suitable sized air conditioning unit .... [quoted text clipped - 10 lines] > help appreciated for the formula to go into Cells E7-E10 > thanks If the figure is less than 9000 how can I get it to show a blank cell....thanks > =LOOKUP(D7,{0,16,23,31},{9000,12000,18000,24000}) > [quoted text clipped - 17 lines] >> help appreciated for the formula to go into Cells E7-E10 >> thanks How does it get to be less than 9000, 9000 was your smallest value? SignatureHTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) > If the figure is less than 9000 how can I get it to show a blank > cell....thanks [quoted text clipped - 20 lines] > >> help appreciated for the formula to go into Cells E7-E10 > >> thanks I suppose to be more accurate....... if they dont put in any figures it currently shows 9000, and it would look better if it were a blank or zero. For example I have set this up for 4 rooms if they only have 2 rooms then the formula works out the required figure for those rooms, the other 2 rooms have no figures (as they would not be required in this example) they would show a default of 9000. I hope this explains. > How does it get to be less than 9000, 9000 was your smallest value? > [quoted text clipped - 23 lines] >> >> help appreciated for the formula to go into Cells E7-E10 >> >> thanks Do either of these help: =LOOKUP(D7,{0,1,16,23,31;0,9000,12000,18000,24000}) =LOOKUP(D7,{0,1,16,23,31;"",9000,12000,18000,24000}) You can make the "1" as small as you like, say 0.1 or 0.001. SignatureHTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- > I suppose to be more accurate....... if they dont put in any figures it > currently shows 9000, and it would look better if it were a blank or zero. [quoted text clipped - 31 lines] > >> >> help appreciated for the formula to go into Cells E7-E10 > >> >> thanks thanks RD that works good. > Do either of these help: > [quoted text clipped - 41 lines] >> >> >> help appreciated for the formula to go into Cells E7-E10 >> >> >> thanks Appreciate the feed-back. SignatureRegards, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- > thanks RD that works good. > [quoted text clipped - 48 lines] > >> >> >> help appreciated for the formula to go into Cells E7-E10 > >> >> >> thanks |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.