Ok If a6 is greater than c3 need to minus one from c6. I don't know how to write the formula
Ok If a6 is greater than c3 need to minus one from c6. I don't know how to write the formula
Last edited by Jg396; 04-14-2013 at 08:37 PM.
Such a formula would be a CIRCULAR REFERENCE and you don't want this. It means your formula refer to itself. Not really a good thing.
You might use a macro to do so.
Pierre Leclerc
_______________________________________________________
If you like the help you got,
Click on the STAR "Add reputation" icon at the bottom.
@ Pierre, I dont see how that will create a circ error?
If you want your answer to be in A1, enter this...
=if(A6>C3,C6-1)
If this is not what you wanted, please provide greater detail
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
@ Tony. True, we will have to see where the OP wants the answer
Guys thank you for the formula it worked great. Thanks again
Seems we'll never know where you wanted the formula to be entered.
If it works, you did not want it to be in C6. That's for sure.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks