Change True/False to Yes/No

[D1sh]

Hi all, my apologies if this has already been asked before but searching didn't seen to come up with the results I was looking for.

So this is the part I've been struggling with. The formulas used to be for H15, H16 and H18 =G15<=0 which would give a True or False result. However if the input for F15 would be 100 H18 would still give a positive result due to the total amount of hours being met. But ofcourse every portion of the training needs to be completed for the entire course to give a positive result. (This course only consists of 2 portions, but others contain many more)

So right now my formulas for H15 and H16 are =IF(G15<=0;"Yes"; "No") and =IF(G16<=0;"Yes"; "No")
And H18 is =AND(H15="Yes"; H15=H16) Because H18 may only give a True result if all portions have been completed.

However, I want H18 to also display a Yes of No value just as the cells above. So I tried several variations on =IF (AND(H15="Yes"; H15=H16); "Yes"; "No") but it always errors out. Am I overlooking something?

I hope this makes sense and I appreciate any help!

 

[Fluff]

There is nothing obviously wrong with the formula, in what way does it "error out"?

 

[D1sh]

There is nothing obviously wrong with the formula, in what way does it "error out"?

So because of this I went back to the formula thinking "If there's nothing obviously wrong, it has to be something dumb" and boy was it!
The space between the IF and the ( was the bad guy.

I feel very smart right now

 

[Fluff]

Glad you sorted it & thanks for letting us know.