Forum Discussion

Ageless's avatar
Ageless
Copper Contributor
Feb 14, 2024
Solved

If function syntax help

I am trying to determine an entry in a cell according to a size. I have tried the following, but with no luck.  I assume my syntax is wrong somewhere. =IF (G13<=235000, [G13], [235000]) is typed in...
  • Harun24HR's avatar
    Feb 14, 2024

    Ageless Remove square bracket. Try-

    =IF(G13<=235000,G13,235000)

     

Resources