Formula help

0705297963

New member
Joined
Jul 18, 2017
Messages
7
Reaction score
0
Points
0
Hi, kindly assist with an excel formula that gives results by referring to the data in three cells only such that the result is either A-yes,B-No,C-maybe. Example1
A90%-B45%-C60% - result is yes.
Example2. A10%-B50%-C20% result is No

Example3. A10%-B20%-C50% result is may be
 
Please explain the logic behind your answers. What determines yes, no and maybe?
 
The % value which will appear on the cell for instance if the values appear as % in cells A1-B1-C1
 
The values in cells A1-B1-C1 are to be entered manually so I expect the formula to appear in cell D1 to read the data from the respective cells
 
The logic here is when value in,
A1>B1,A1>C1 result is yes
B1>A1,B1>C1 result is No

C1>A1,C1>B1 result is may be
 
Back
Top