I am having problems with a formula.
I need to put a total in a cell, 50 points minus two other cells. The trouble is that the 50 comes up all the time and I want it to just say 0 when I haven’t enter an amount in AI18 and AJ18. Any suggestions?
I am having problems with a formula.
I need to put a total in a cell, 50 points minus two other cells. The trouble is that the 50 comes up all the time and I want it to just say 0 when I haven’t enter an amount in AI18 and AJ18. Any suggestions?
Try this:
=IF(COUNT(AI18:AJ18)=2, 50-SUM(AI18:AJ18), 0)
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
excel is saying there is a mistake :-(
if you post a book it would be easier but i cant see why that formula wouldnt work!
The Importance of INDEX - A GUIDE TO INDEX'S OTHER USES
<--- If a post helps hit the star
I am new to "excel" what is a "book"?
as in your workbook the excell file your using when you post click go advanced then click the atach icon and attach it (a sample if the data is sensative)
or try this
it was pointed out to me that your version of excel may use ; instead of the , in formulasPlease Login or Register to view this content.
I have been playing around with the formula and this seems to work
=IF(AI18+AJ18<1;"0";50-AI18-AJ18)
thanks for the help.
I have marked this thread solved for you.
In the future please select Thread Tools from the menu above and mark the thread as solved. Thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks