Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If formula ?
Is ther a better way I keep getting error to many Arguments
=if(Y8=7,(AR23+20),(AR23),if(J20+20=J17,(E23+H26+ 10))) Thanks, Lime |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If formula ?
You have too many arguments for your IF function
=if(Y8=7, (AR23+20), (AR23), if(J20+20=J17,(E23+H26+10))) value if true value if false this is not necessary for your IF "Lime" wrote: Is ther a better way I keep getting error to many Arguments =if(Y8=7,(AR23+20),(AR23),if(J20+20=J17,(E23+H26+ 10))) Thanks, Lime |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If formula ?
"Lime" wrote:
Is ther a better way I keep getting error to many Arguments =if(Y8=7,(AR23+20),(AR23),if(J20+20=J17,(E23+H26+ 10))) Not a question of "better". You simply have the wrong format. To help you, it would be useful if you could express your intended logic in English. For example (wild guess): if Y8=7, then AR23+20 else if J20+20 = J17, then E23+H26+10 else AR23 That can be expressed as: =IF(Y8=7, AR23+20, IF(J20+20 = J17, E23+H26+10, AR23)) |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If formula ?
Here is what I'm trying to do.
if Y8=7 then AR23+20 if not than show what's in AR23 else if J20+20 = J17, then E23+H26+10 Thanks, Lime " wrote: "Lime" wrote: Is ther a better way I keep getting error to many Arguments =if(Y8=7,(AR23+20),(AR23),if(J20+20=J17,(E23+H26+ 10))) Not a question of "better". You simply have the wrong format. To help you, it would be useful if you could express your intended logic in English. For example (wild guess): if Y8=7, then AR23+20 else if J20+20 = J17, then E23+H26+10 else AR23 That can be expressed as: =IF(Y8=7, AR23+20, IF(J20+20 = J17, E23+H26+10, AR23)) |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If formula ?
Here is what I'm trying to do.
if Y8=7 then AR23+20 if not than show what's in AR23 but if J20+20 = J17, then E23+H26+10 "Lime" wrote: Here is what I'm trying to do. if Y8=7 then AR23+20 if not than show what's in AR23 else if J20+20 = J17, then E23+H26+10 Thanks, Lime " wrote: "Lime" wrote: Is ther a better way I keep getting error to many Arguments =if(Y8=7,(AR23+20),(AR23),if(J20+20=J17,(E23+H26+ 10))) Not a question of "better". You simply have the wrong format. To help you, it would be useful if you could express your intended logic in English. For example (wild guess): if Y8=7, then AR23+20 else if J20+20 = J17, then E23+H26+10 else AR23 That can be expressed as: =IF(Y8=7, AR23+20, IF(J20+20 = J17, E23+H26+10, AR23)) |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If formula ?
"Lime" wrote:
Here is what I'm trying to do. if Y8=7 then AR23+20 if not than show what's in AR23 else if J20+20 = J17, then E23+H26+10 That does not even make sense in English. The first statement (if ... then ...; if not, then ...) precludes the else-if. (Hint: What should the result be if J20+20 < 17?) I tried to fix that by suggesting that perhaps you want AR23 only if Y8<7 __and__ J20+20 < J17. But either you did not understand my fix (which is correct for that purpose), or my guess is incorrect. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hide formula | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
IF & VLOOKUP FORMULA | Excel Worksheet Functions | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) | |||
Help with macro formula and variable | Excel Worksheet Functions |