Posted to microsoft.public.excel.misc

Confused in Nebraska Confused in Nebraska is offline

external usenet poster

Posts: 1

simple formula question

If I enter between 50 and 99 I would like the cell to enter 3, between
100-150, 5 should go in the cell and above 151 I would like the cell to read
7.
Any help would be appreciated

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
Simple formula question	kleivakat	Excel Discussion (Misc queries)	7	May 9th 08 05:33 PM
Formula question -simple for those who know	Diane	New Users to Excel	5	March 14th 08 06:07 PM
Simple Formula Question	Dax Arroway	Excel Discussion (Misc queries)	4	February 5th 08 09:43 PM
IF formula-simple question; simple operator	Rich D	Excel Discussion (Misc queries)	4	December 6th 07 03:36 PM
Simple Formula Question	chip_pyp	Excel Discussion (Misc queries)	1	December 8th 05 07:01 PM

All times are GMT +1. The time now is 05:50 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us