Posted to microsoft.public.excel.newusers

Gerald

Posts: n/a

formulae

hi,

I have a field which does calculation on the IF condition, does fine till
have a negative conditon

e.g. =IF(H3<=-4000,"CAMERA",IF(H3<=-8000,"PRINTER"))

now the statement comes in field 'I' e.g. CAMERA etc.

tried having the amount in () still does not show up

also can I have both the + and - conditon in on IF statement

please advise

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
Displaying formulae changes formatting	SueJB	Excel Worksheet Functions	4	May 8th 06 01:01 PM
Change to formulae	Emma Hope	Excel Worksheet Functions	3	September 5th 05 09:16 PM
Searching TEXT in formulae, rather than results of formulae	AndyE	Excel Worksheet Functions	1	July 15th 05 10:57 AM
Dynamic formulae - similar to lotus 123 for excel	JohnD	Excel Discussion (Misc queries)	1	July 5th 05 11:41 PM
XL2002 Clipboard doesn't paste formulae	Jonathan	Excel Discussion (Misc queries)	2	May 23rd 05 12:17 PM

All times are GMT +1. The time now is 02:34 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us