How to write a formulae

Posted to microsoft.public.excel.worksheet.functions

Jules

external usenet poster

Posts: 86

How to write a formulae

I need a formulae for the below logic ..can you help me?
If B42 < 2%, multiply it by 5. If = 2%, multiply by 10

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
Formulae: Paste value formulae after doing an average operation	Lim	Excel Discussion (Misc queries)	4	April 20th 08 07:31 PM
who can write Excel Formulae	Craig Wargel	Excel Worksheet Functions	9	March 5th 07 07:14 PM
formulae	Sparky AKA_Sparkticus	Excel Discussion (Misc queries)	4	December 8th 06 06:50 AM
Searching TEXT in formulae, rather than results of formulae	AndyE	Excel Worksheet Functions	1	July 15th 05 10:57 AM
is it possible to execute write to the fields in another .xsl form a macro in another .xsl? e.g. some way to load another .xsl into an .xsl macro and write to its data?	Daniel	Excel Worksheet Functions	1	June 23rd 05 11:38 PM

All times are GMT +1. The time now is 01:20 PM.

About Us