Menu

help creating a formula using IF and AND

Search this Thread

Prev

Previous Post

Next Post

Next

#1

Report Post

Posted to microsoft.public.excel.worksheet.functions

[email protected]

Posts: n/a

Default

help creating a formula using IF and 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 A2 is not greater than A1 then A4 should be multiplied by .03.

Reply With Quote

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

All times are GMT +1. The time now is 11:51 PM.

About Us

"It's about Microsoft Excel"

Contact Us ExcelBanter forum home Privacy Statement