| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need HELP!! IF OR formula driving me crazy!!!!
=IF(B6=IN,A6+C6)*OR(B6=OUT,A6-C6)...........The first part of the formula
works but the cell won't recognise the second part!! I need cell B6 to do 1 sum if I enter IN and another sum if I enter OUT?? Any ideas please??? Caz |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Need HELP!! IF OR formula driving me crazy!!!!
It is easier than you are making it...
=if(B6="IN", A6+C6, if(B6="OUT", A6-C6, "NoValue)) -- HTH... Jim Thomlinson "caz - can't use excel!!" wrote: =IF(B6=IN,A6+C6)*OR(B6=OUT,A6-C6)...........The first part of the formula works but the cell won't recognise the second part!! I need cell B6 to do 1 sum if I enter IN and another sum if I enter OUT?? Any ideas please??? Caz |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Need HELP!! IF OR formula driving me crazy!!!!
"caz - can't use excel!!" <caz - can't use
wrote: =IF(B6=IN,A6+C6)*OR(B6=OUT,A6-C6)...........The first part of the formula works but the cell won't recognise the second part!! I need cell B6 to do 1 sum if I enter IN and another sum if I enter OUT?? Any ideas please??? If B6 can be only "IN" or "OUT", try one of the following equivalent forms, whichever is easier for you to understand and possibly modify in the futu =if(B6="in", A6+C6, A6-C6) =A6 + if(B6="in", C6, -C6) If B6 can have other values (or none), you need to specify what you want with B6 is neither "IN" nor "OUT". Try: =if(B6="in", A6+C6, if(B6="out", A6-C6, "")) |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Need HELP!! IF OR formula driving me crazy!!!!
Try:
=IF(B6="IN",A6+C6,IF(B6="out",A6-C6,"")) If b6 is empty, you get nothing. Cliff Edwards |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Need HELP!! IF OR formula driving me crazy!!!!
Ooops missed a quote...
=if(B6="IN", A6+C6, if(B6="OUT", A6-C6, "NoValue")) -- HTH... Jim Thomlinson "Jim Thomlinson" wrote: It is easier than you are making it... =if(B6="IN", A6+C6, if(B6="OUT", A6-C6, "NoValue)) -- HTH... Jim Thomlinson "caz - can't use excel!!" wrote: =IF(B6=IN,A6+C6)*OR(B6=OUT,A6-C6)...........The first part of the formula works but the cell won't recognise the second part!! I need cell B6 to do 1 sum if I enter IN and another sum if I enter OUT?? Any ideas please??? Caz |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Need HELP!! IF OR formula driving me crazy!!!!
You are AMAZING!!! THANK YOU!!!
1 Question though.............How???? "Jim Thomlinson" wrote: It is easier than you are making it... =if(B6="IN", A6+C6, if(B6="OUT", A6-C6, "NoValue)) -- HTH... Jim Thomlinson "caz - can't use excel!!" wrote: =IF(B6=IN,A6+C6)*OR(B6=OUT,A6-C6)...........The first part of the formula works but the cell won't recognise the second part!! I need cell B6 to do 1 sum if I enter IN and another sum if I enter OUT?? Any ideas please??? Caz |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Need HELP!! IF OR formula driving me crazy!!!!
Works without the "novalue" does this make a difference??
"Jim Thomlinson" wrote: Ooops missed a quote... =if(B6="IN", A6+C6, if(B6="OUT", A6-C6, "NoValue")) -- HTH... Jim Thomlinson "Jim Thomlinson" wrote: It is easier than you are making it... =if(B6="IN", A6+C6, if(B6="OUT", A6-C6, "NoValue)) -- HTH... Jim Thomlinson "caz - can't use excel!!" wrote: =IF(B6=IN,A6+C6)*OR(B6=OUT,A6-C6)...........The first part of the formula works but the cell won't recognise the second part!! I need cell B6 to do 1 sum if I enter IN and another sum if I enter OUT?? Any ideas please??? Caz |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Need HELP!! IF OR formula driving me crazy!!!!
One answer... Practice...
-- HTH... Jim Thomlinson "caz - can''t use excel!!" wrote: You are AMAZING!!! THANK YOU!!! 1 Question though.............How???? "Jim Thomlinson" wrote: It is easier than you are making it... =if(B6="IN", A6+C6, if(B6="OUT", A6-C6, "NoValue)) -- HTH... Jim Thomlinson "caz - can't use excel!!" wrote: =IF(B6=IN,A6+C6)*OR(B6=OUT,A6-C6)...........The first part of the formula works but the cell won't recognise the second part!! I need cell B6 to do 1 sum if I enter IN and another sum if I enter OUT?? Any ideas please??? Caz |
|
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Need HELP!! IF OR formula driving me crazy!!!!
The "NoValue" part is for when cell B6 contains something other than "IN" or
"OUT". You might want to change the "NoValue" to just "" so that nothing is displayed for those conditions... =IF(B6="IN",A6+C6,IF(B6="OUT",A6-C6,"")) -- Rick (MVP - Excel) "caz - can''t use excel!!" wrote in message ... Works without the "novalue" does this make a difference?? "Jim Thomlinson" wrote: Ooops missed a quote... =if(B6="IN", A6+C6, if(B6="OUT", A6-C6, "NoValue")) -- HTH... Jim Thomlinson "Jim Thomlinson" wrote: It is easier than you are making it... =if(B6="IN", A6+C6, if(B6="OUT", A6-C6, "NoValue)) -- HTH... Jim Thomlinson "caz - can't use excel!!" wrote: =IF(B6=IN,A6+C6)*OR(B6=OUT,A6-C6)...........The first part of the formula works but the cell won't recognise the second part!! I need cell B6 to do 1 sum if I enter IN and another sum if I enter OUT?? Any ideas please??? Caz |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Driving me CRAZY~ please help | New Users to Excel | |||
| Formula driving me crazy | Excel Discussion (Misc queries) | |||
| Formula is driving me crazy????? | Excel Worksheet Functions | |||
| basic...but driving me crazy! | Excel Discussion (Misc queries) | |||
| HELP!? Passwords are driving me crazy. | Excel Worksheet Functions | |||
Linear Mode
