|
formala 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 |
formala help required.
=VLOOKUP(D7,{0,9000;16,12000;23,18000;31,24000},2)
-- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "S S" wrote in message . uk... 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 |
formala help required.
Excellent! thanks for your speedy and accurate response.
"Bob Phillips" wrote in message ... =VLOOKUP(D7,{0,9000;16,12000;23,18000;31,24000},2) -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "S S" wrote in message . uk... 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 |
formala help required.
in E7:
=LOOKUP(D7,{0,16,23,31},{9000,12000,18000,24000}) Copy down to E10. HTH "S S" wrote: 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 |
formala help required.
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}) Copy down to E10. HTH "S S" wrote: 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 |
formala help required.
How does it get to be less than 9000, 9000 was your smallest value?
-- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "S S" wrote in message . uk... 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}) Copy down to E10. HTH "S S" wrote: 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 |
formala help required.
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. "Bob Phillips" wrote in message ... How does it get to be less than 9000, 9000 was your smallest value? -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "S S" wrote in message . uk... 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}) Copy down to E10. HTH "S S" wrote: 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 |
formala help required.
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. -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "S S" wrote in message . uk... 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. "Bob Phillips" wrote in message ... How does it get to be less than 9000, 9000 was your smallest value? -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "S S" wrote in message . uk... 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}) Copy down to E10. HTH "S S" wrote: 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 |
formala help required.
thanks RD that works good.
"Ragdyer" wrote in message ... 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. -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "S S" wrote in message . uk... 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. "Bob Phillips" wrote in message ... How does it get to be less than 9000, 9000 was your smallest value? -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "S S" wrote in message . uk... 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}) Copy down to E10. HTH "S S" wrote: 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 |
formala help required.
Appreciate the feed-back.
-- Regards, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "S S" wrote in message k... thanks RD that works good. "Ragdyer" wrote in message ... 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. -- HTH, RD -------------------------------------------------------------------------- - Please keep all correspondence within the NewsGroup, so all may benefit ! -------------------------------------------------------------------------- - "S S" wrote in message . uk... 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. "Bob Phillips" wrote in message ... How does it get to be less than 9000, 9000 was your smallest value? -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "S S" wrote in message . uk... 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}) Copy down to E10. HTH "S S" wrote: 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 |
| All times are GMT +1. The time now is 01:40 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com