Simple IF Statement Not Working

[gregorii77]

In the spreadsheet (see the Tab "Sheet1"), I have what I thought was a pretty simple table. I am evaluating the ratios in all the highlighted cells to see if they are <1.5. If they are less than 1.5, then the segment is reliable (YES), if it's > 1.5, then it's a NO. For some reason, I cannot get F13 to evaluate to YES in F14. Did I miss something? Any assistance would be great and thank you.

G

 

[SirJB7]

Hi, gregorii77!
Check your uploaded workbook, in worksheet Sheet 1 there's almost no data, cols A:B thru row 6, col C only row 2, and other columns empty.
Regards!

 

[PaulF]

Look at your If statements F2. You should have a comma after your logical statement of =IF(MEDIAN(TIME(6,0,0),TIME(10,0,0),D2)=D2 << should be a comma next with your true statement not *(E2="Y")... If you analyse your formula you will end up with: =IF((TRUE)*("Y"="Y"),1,3)

 

[gregorii77]

@SirJB7-ah yes, my apologies. See uploaded file, same as my previous post. Thank you PaulF. Makes sense.

 

[SirJB7]

Hi, gregorii77!
Which regional settings are you using? In F13 I have a value of 1500, one thousand and a half, that I see as 1,500 formatted. This will never satisfy 1 of the 3 conditions of the AND(), since it says "F13<1,5".
Regards!

 

[gregorii77]

Where can I go to determine that? I see it as 1.5. Sorry for the inconvenience. I didn't reformat anything. Thanks.

 

[SirJB7]

Hi, gregorii77!
Nothing to apologize for, I'm trying to find out if it's a Windows setup isseu.
In your desktop, go to Start, Control Panel, Clock Language & Region, Regional & Language Configuration, Change Date Hour or Number Format., Additional Configuration.
There check at Decimal Symbol if you have a dot or a comma.
Regards!

 

[gregorii77]

Gotcha. Okay, I have a decimal symbol (.) in the aforementioned spot.

 

[NARAYANK991]

Hi ,

I am not sure what is being discussed here ; if we are discussing the IF statement , one of the checks that your IF statement is doing is to see whether F13 is less than 1.5 ; since F13 is exactly 1.5 , it is not less than 1.5 , and so the IF statement evaluates to False , and hence F14 displays NO.

Would you want it otherwise ?

Narayan