Formula not reading

[eramirez148]

Hello I have an issue.

I pulled data into column P and S using a formula =IF(O5<=0,"0","20"). With this formal if column O or R is less than zero then it equals to 20 or 19. However on column N I am trying to get the MAX number using =MAX() and nothing populates because the numbers in column P and S and calculated with a formula? Is there anything I can do to have this fix and populate the MAX number from column P and S without loosing the formula already existing in P and S?

Please reference the attached image

 

[etaf]

no, its because you have used "" so not a number but text
change to

=IF(O5<=0,0,20)

now they are numbers