LinkBack URL
About LinkBacks
Ok the below formula is working well, however I now need to add an independent formula "SUM(A4,B4)/2*M4" to the same cell to return either or both results, can I do this?
=IF(AND(AJ12=TRUE,AH12=Data!$K$3),Data!L3)
Ok the below formula is working well, however I now need to add an independent formula "SUM(A4,B4)/2*M4" to the same cell to return either or both results, can I do this?
=IF(AND(AJ12=TRUE,AH12=Data!$K$3),Data!L3)
Not sure where do you want to implement it and how? can you please explain it a bit more??
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
based on what?
write the new formula as you think it should be - dont worry about syntax or "correct" wording - just write it out how you would say it. We can take it from there
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
I need two arguments in the same cell with either or both values returned
Argument 1. cell 1 + cell 2 divided by cell 3 multiplied by cell 4
Argument 2. =IF(AND(AJ12=TRUE,AH12=Data!$K$3),Data!L3)
How the both arguments should be shown?? should be added or??
FD's 1k point may have made him a little giddy(and congrats btw!)
I would like to see some kind of expected output at least...lol
A picture may be worth a thousand words, BUT, a sample Workbook is worth a thousand screenshots!
-Add a File - click advanced (next to quick post), scroll to manage attachments, click, select add files, click select files, select file, click upload, when file shows up at bottom left, click done (bottom right), click submit
-To mark thread Solved- go top of thread,click Thread Tools,click Mark as Solved
If you received helpful response, please remember to hit the * of that post
that still doesnt tell us how argument 1 fits into argument 2?
Also, assuming A1 = 1 A2 = 2, A3 = 3, A4 = 4...
argument 1 formula could be...(A1+A2)/A3*A4 = 5.00...or it could be....A1+(A2/A3)*A4 = 4.333...or it could be....(A1+(A2/A3))*A4 = 8.3333....and there are other variations too. You really need to be more specific in your explanations!
lol i got 1100 now dred, but thanks a bunch though
Yes show the PRODUCT of both results
Hensgen, if you expect realist help, instead of pure guess work regarding what you mean, and what you are trying to do, PLEASE explain clearly what you are trying to do. remember, you know exactly what you want, we have no clue, we are relying on you to explain to us
Although this is honestly NOT how I like to do this, from your explanation, the result of the if formula gets multiplied by the other formula?
=IF(AND(AJ12=TRUE,AH12=Data!$K$3),Data!L3) * SUM(A4,B4)/2*M4
not sure this is what you want, because if the IF formula results in a false, all you are goting to get is 0...but this is all I can understand of what you've posted so far...
dredwolf, FDibbins, thanks in advance for your continued patience....
=IF(AND(AJ12=TRUE,AH12=Data!$K$3),Data!L3) * SUM(A4,B4)/2*M4
what I require - if the formula returns "TRUE" then Data!L3 + SUM(A4,B4)/2*M4
If the formula returns "FALSE" then SUM(A4,B4)/2*M4 only in required
What a strange thread - reminds me of the saying "... like getting blood from a stone ..."
Anyway, I think you mean this:
Formula:
Please Login or Register to view this content.
Hope this helps.
Pete
=IF(AND(AJ12=TRUE,AH12=Data!$K$3),Data!L3+SUM(A4,B4)/2*M4,SUM(A4,B4)/2*M4)
Edit: and i think this...now there are many confused .
I think people forget the word "THANK YOU!!!!" Do you still know it???
There is a little star ( ADD REPUTATION ) below those person who helped you. Click it to say your "PRIVATE APPRECIATION TO THEIR EFFORT ON THEIR CONTRIBUTIONS "
Regards,
Vladimir
vlady, well done, this seems to be delivering what i require............thanks for your help
will now run some further simulations to test it
Ok, the formula is working well, I now need to reiterate the formula many times (each time with modified reference cells) in the same cell
Eg: =IF(AND(AJ12=TRUE,AH12=Data!$K$3),Data!L3+SUM(A4,B4)/2*M4,SUM(A4,B4)/2*M4,IF(AND(AJ12=TRUE,AH12=Data!$K$4),Data!L4+SUM(A5,B5)/2*M5,SUM(A5,B5)/2*M5)))
however I cant get this to work as there seems to be a missing parenthesis?
can you try this one. Not Tested.
Formula:Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks