Posted to microsoft.public.excel.misc

Posts: n/a

help create a formula using the IF command with AND

I need to create a formula for below:

IF A2 is greater than A1 AND A4A3 then A4 should be multiplied by .04,
if not then A4 should be multiplied by .03. Can someone turn that into
a formula for me?

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 can I create a formula for Salutation	cs_vision	Excel Discussion (Misc queries)	6	October 8th 05 12:31 AM
Create Formula for calculating Little League Age...	Brent	Excel Worksheet Functions	1	September 21st 05 01:19 AM
How to create specific formula	STS	Excel Worksheet Functions	4	May 2nd 05 01:44 AM
How do I create a formula that would allow me to subtract from a d	Justlearning	New Users to Excel	5	January 27th 05 09:47 PM
How do I create a formula in Excel that will countif or sumif bef.	bkclark	Excel Worksheet Functions	4	November 10th 04 05:30 PM

All times are GMT +1. The time now is 08:59 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us