Report

See more
# Trying to create a multi-column formula. [Solved]

Ask a question
oduana777
6Posts
Thursday January 12, 2017Registration date
February 21, 2017
Last seen
- Last answered on Feb 23, 2017 at 11:14 AM
by TrowaD

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