Hi Oduana777,
You can combine the IF formula with the ISERROR formula to take care of the error message. For example =(IF(ISERROR(YOURFORMULA),YourFormulaWhenErrorOcurred,YourFormulaWhenItDoesn't)
But I am a bit confused by your example. You say that either AF or AM can be blank, but those values are the upper part of the division and thus won't create the error (0/1=0).
So I'm assuming that either AE, AG or AN can be blank.
Set A formula: =IF(AE2="","",(AF2/AE2)*100)
X formula: =IF(AG2="","",((AF2/AE2)*100)/AG2)
Or combine them in one formula:
=IF(OR(AE2="",AG2=""),"",((AF2/AE2)*100)/AG2)
Hopefully I understood you correctly and this helps you out.
Do let me know how this works out for you.
Best regards,
Trowa
What you gave me worked great!
I have redesigned the formulas to remove negative integers but I have a few problems I don't know how to fix. I hope you don't mind helping me again!
Basically I mathematically manipulating two basic sets of data to compare them with each other after running them through some division and percentages.
After both sets are done I want to compare them to see what is the highest value between the two sets (MAX?)
SET A has values 85% of the time and SET B has values 55% of the time and 15% of the time both SETS A&B are blank cells with no data. How do I tell Excel to ignore the data set that has no data this time and just give me the value of the set that does have data?
Here is some messages I getting:
SET A is ((AF2/AE2)*100 THEN THAT IS DIVIDED BY AG2 NOW COLUMN X
SET B is ((AM2/AE2)*100 THEN THAT IS DIVIDED BY AN2 NOW COLUMN AJ
I NEED THE LARGEST NUMERICAL VALUE BETWEEN THE RESULTS THAT ARE COLUMNS X AND AJ WITHOUT EXCEL DOING A #DIV/0! BECAUSE OF THE BLANK CELLS IN EITHER COLUMNS AF OR AM.
I TRIED COLUMN AP AS =MAX(X2,AJ2) BUT THE ERROR MESSAGES FROM THE BLANKS IN AF OR AM STOP IT FROM FUNCTIONING.
THANKS SO MUCH!!!
OdUANA 777