Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF, OR, AND FUNCTION HELP
This is my actual formula.
=IF(OR(AND(D$25="GENERAL",D$25="THIEME"),($F$5*33)-(D$58+D$59)0),($F$5*33)-(D$58+D$59),IF(OR(AND(D$25="EAGLE",D$25="GENIE",D$ 25="APACHE"),($F$5*28)-(D$58+D$59)0),($F$5*28)-(D$58+D$59),0)) I need it to return 44 if D25=General or Thieme, and return 19 if Eagle, Genie, or Apache. Right now, it returns 44, regardless of what I put in D25. D25=Genie, F5=5, D58=121, D59=0 It is calculating 5*33-121, and I need it to calculate 5*28-121 Any help would be greatly appreciated. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF, OR, AND FUNCTION HELP
On Jul 3, 10:22 am, talltom wrote:
This is my actual formula. =IF(OR(AND(D$25="GENERAL",D$25="THIEME"),($F$5*33)-(D$58+D$59)0), ($F$5*33)*-(D$58+D$59),IF(OR(AND (D$25="EAGLE",D$25="GENIE",D$25="APACHE"),($F$5*28 )-(*D$58+D$59)0), ($F$5*28)-(D$58+D$59),0)) I need it to return 44 if D25=General or Thieme, and return 19 if Eagle, Genie, or Apache. Right now, it returns 44, regardless of what I put in D25. D25=Genie, F5=5, D58=121, D59=0 It is calculating 5*33-121, and I need it to calculate 5*28-121 Ostensibly, reverse the order of OR and AND. That is: AND(OR(D$25="GENERAL",D$25="THIEME"),($F$5*33)-(D$58+D$59)0) However, I suspect the following simplification will work equally well for you, and it might be easier to read and maintain: =IF(OR(D$25="GENERAL",D$25="THIEME"), MAX(0, $F$5*33 - (D$58+D$59)), IF(OR(D$25="EAGLE",D$25="GENIE",D$25="APACHE"), MAX(0, $F$5*28 - (D$58+D$59)) , 0)) |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF, OR, AND FUNCTION HELP
Thank You Joe. This is working great. I am using the option you offered.
"joeu2004" wrote: On Jul 3, 10:22 am, talltom wrote: This is my actual formula. =IF(OR(AND(D$25="GENERAL",D$25="THIEME"),($F$5*33)-(D$58+D$59)0), ($F$5*33)--(D$58+D$59),IF(OR(AND (D$25="EAGLE",D$25="GENIE",D$25="APACHE"),($F$5*28 )-(-D$58+D$59)0), ($F$5*28)-(D$58+D$59),0)) I need it to return 44 if D25=General or Thieme, and return 19 if Eagle, Genie, or Apache. Right now, it returns 44, regardless of what I put in D25. D25=Genie, F5=5, D58=121, D59=0 It is calculating 5*33-121, and I need it to calculate 5*28-121 Ostensibly, reverse the order of OR and AND. That is: AND(OR(D$25="GENERAL",D$25="THIEME"),($F$5*33)-(D$58+D$59)0) However, I suspect the following simplification will work equally well for you, and it might be easier to read and maintain: =IF(OR(D$25="GENERAL",D$25="THIEME"), MAX(0, $F$5*33 - (D$58+D$59)), IF(OR(D$25="EAGLE",D$25="GENIE",D$25="APACHE"), MAX(0, $F$5*28 - (D$58+D$59)) , 0)) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
LINKEDRANGE function - a complement to the PULL function (for getting values from a closed workbook) | Excel Worksheet Functions | |||
Offset function with nested match function not finding host ss. | Excel Worksheet Functions | |||
Emulate Index/Match combo function w/ VBA custom function | Excel Worksheet Functions | |||
I want to use Vlookup function and AND function in a single formu. | Excel Worksheet Functions | |||
Nested IF Function, Date Comparing, and NetworkDays Function | Excel Worksheet Functions |