Working with formula outputs and "logical values"

[Paulkontheriver]

Hello, I’m a first-time poster so hopefully I have this in the right spot. I'm OK getting around Excel but find myself learning more than I ever thought I would.
I am trying to find the largest value in a column of “logical values”. These “Logical values” are values that are populated by formulas in the cells of the column.
The range of cells I am looking at are K297 through K300. The formulas in those cells are as follows:

*Formula in K297* =IF($K290<>0, "0.03", "NA")
*Formula in K298* =IF($K291<>0, "0.03", "NA")
*Formula in K299* =IF($K292<>0, "0.05", "NA")
*Formula in K300* =IF($K293<>0, "0.01", "NA")

I used the following formula to look for the largest number in the range of cells:

*Formula in K304* =MAX(K297:K300)

This didn’t work and just returns a "0". I was expecting it to have returned a "0.05" (output of the formula in K299 was true). Excel gave the message that “text and logical values are ignored”. This worked if I have just text entered numbers.

Any suggestions on how to make this work?
Thanks!

[StuartR]

The values "0.03" etc are text strings. Remove the "" marks so that they are numbers and you should get what you are looking for.
*Formula in K297* =IF($K290<>0, 0.03, "NA")
*Formula in K298* =IF($K291<>0, 0.03, "NA")
*Formula in K299* =IF($K292<>0, 0.05, "NA")
*Formula in K300* =IF($K293<>0, 0.01, "NA")

[Paulkontheriver]

That did it! Thank you!
Appreciate the help and quick response.