Posted to microsoft.public.excel.misc

MarkW1307

external usenet poster

Posts: 6

Formula Help required!

I am trying to set a formula to achieve the following and would appreciate
any assistance:
I have a number in a cell which if less than 7 should show 7 but if greater
than 7 and less than 25 should display itself and greater than 25 should show
25.
i.e 3.4 shows 7; 9.5 shows 9.5; 28 shows 25 i can do any two of these but
not all 3. Please help!

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
formula required	Trevor	Excel Worksheet Functions	2	September 7th 07 01:02 AM
Excel 2002 Formula: Urgent Conditional Formula Required Right Away - if possible	blue[_2_]	Excel Discussion (Misc queries)	2	July 11th 07 06:08 PM
Formula required	shaji	Excel Discussion (Misc queries)	3	February 19th 07 01:56 PM
Formula Required	Funkyfido	Excel Worksheet Functions	2	January 25th 06 10:30 AM
Help Required With IF AND Formula	Ian	Excel Worksheet Functions	3	February 25th 05 12:30 PM

All times are GMT +1. The time now is 03:41 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us