Posted to microsoft.public.excel.newusers

Newie

external usenet poster

Posts: 1

Can I use the argument: - IF, AND, THEN, ElSE

I have created a formula using IF,THEN,ELSE but, I now find that my IF
argument needs to refer to two cells.
i.e.
=if(a1<=0,(and)b1<5,0,A1*b1)

Can anyone advise how this can be done

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
how to use the argument funcation	M. Srinivasa Rao	Excel Worksheet Functions	1	October 7th 06 09:31 AM
what is an argument?	mcockrel	Excel Discussion (Misc queries)	7	March 17th 06 03:21 PM
if argument?	Struggling of Essex	Excel Discussion (Misc queries)	6	December 31st 05 09:48 AM
One more Argument.	Steved	Excel Worksheet Functions	1	July 28th 05 08:55 AM
IF THEN argument	Julie Holeman	Excel Discussion (Misc queries)	3	January 26th 05 04:22 PM

All times are GMT +1. The time now is 03:58 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us