Posted to microsoft.public.excel.worksheet.functions

Beena K[_2_] Beena K[_2_] is offline

external usenet poster

Posts: 1

Formula help required

I have 3 conditions
score divided into 3 parts 50, 75 and 100 %
If score in cell = 27 then -3
If score in cell = 26<36 = -2
If score in cell = 18<27 = -1
My formula

=IF(F4827,"-3",IF(F48=26<36,"-2",IF(F48<=18<27,"-1")))
If score in cell is 27 shows false
Please advise
Cordially
Beena K
Process Analst

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.	sherbrooke[_2_]	Excel Discussion (Misc queries)	22	January 26th 09 07:21 PM
Formula required	Funkyfido	Excel Worksheet Functions	5	December 17th 08 01:11 PM
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 Help Required	DJuan	Excel Discussion (Misc queries)	4	January 22nd 07 06:02 PM
Help required for formula	recklaw	Excel Discussion (Misc queries)	2	March 15th 06 11:11 AM

All times are GMT +1. The time now is 02:37 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us