| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
IF Formula with AND added (I think)
Try the below
=IF(AND(B8=1,F15=1,G11D56),F11*B27,0) If this post helps click Yes --------------- Jacob Skaria "Mark D" wrote: 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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
IF Formula with AND added (I think)
You may try the following
=if(and(B8=1,F15=1,G11D56),F11*B27,0) Mujeeb "Mark D" wrote: 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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
IF Formula with AND added (I think)
Excellent
Thank you both, both examples worked perfectly. "Mujeeb ur Rehman, FBL-GRW-PK" wrote: You may try the following =if(and(B8=1,F15=1,G11D56),F11*B27,0) Mujeeb "Mark D" wrote: 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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula is being added automatically | Excel Discussion (Misc queries) | |||
| Rows added after refresh not in formula | Excel Worksheet Functions | |||
| $ added to formula automatically | Excel Worksheet Functions | |||
| How do I keep a formula from changing if a row is added or deleted | Excel Discussion (Misc queries) | |||
| How do I keep a formula from changing if a row is added or delete. | Excel Discussion (Misc queries) | |||
![Mark D[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
