Posted to microsoft.public.excel.worksheet.functions

S S

external usenet poster

Posts: 38

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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
Make text cells and combo boxes required?	mlroy@savvis	Excel Discussion (Misc queries)	2	July 24th 06 08:19 PM
can you make a cell value required?	nishapurohit	Excel Discussion (Misc queries)	2	January 30th 06 11:42 PM
highlighting required fields	maryann	Excel Worksheet Functions	2	June 23rd 05 06:16 PM
SPECIFY REQUIRED PAPER SIZE IN EXCEL 2000	Augustine	Excel Discussion (Misc queries)	0	January 17th 05 12:05 PM
Rate of return required formula	Alorasdad	Excel Worksheet Functions	1	November 18th 04 03:14 AM

All times are GMT +1. The time now is 09:06 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us