Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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 |