Posted to microsoft.public.excel.worksheet.functions

Mark D[_2_] Mark D[_2_] is offline

external usenet poster

Posts: 52

IF Formula with AND added (I think)

Morning all, desperately after some help if possible.

I have tried doing the following calculation but to no avail.

=SUMPRODUCT($B$8=1)*($F$15=1)*AND(IF(G11D56,F11*B 27,0))

What I am trying to say is as follows

If B8=1 and F15=1 and if G11 is greater than D56 take F11 and * by B27, if
not put 0.

But all I am getting is #value

Can anybody please help me

Thank you in advance

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
Formula is being added automatically	Andrew G	Excel Discussion (Misc queries)	1	August 28th 07 12:07 AM
Rows added after refresh not in formula	Greg Snidow	Excel Worksheet Functions	11	November 21st 06 08:32 PM
$ added to formula automatically	Steve	Excel Worksheet Functions	0	March 4th 05 09:51 AM
How do I keep a formula from changing if a row is added or deleted	cwolt	Excel Discussion (Misc queries)	1	December 27th 04 11:18 PM
How do I keep a formula from changing if a row is added or delete.	cwolterman	Excel Discussion (Misc queries)	1	December 27th 04 09:13 PM

All times are GMT +1. The time now is 10:32 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us