I need to be able to perform conditional processing (not formating) without using the IF statement. Once created the spreadsheet will be converted and the convertor does not (yet) support conditional processing. I need to be able to perform a calculation and default the answer to a cell ref if the resulting answer is less than the cell ref.
Does anyone have any suggestions as to how this can be accomplished - Thanks in advance.
Last edited by Solihull; 03-13-2011 at 06:04 PM.
Can you explain more fully
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
Hi - please see the enclosed for a better explaination:
http://www.bureau-payroll.com/problem.htm
Why the web page? We are talking about Excel, an example workbook is what is needed
Click on the "Go Advanced" below the message area and then on the Paper Clip Icon above the message area to attach an Excel file.
One test is worth a thousand opinions.
Here is the spreadsheet file
I've solved this question using an array and the =Large function.
Thanks for your input
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks