Feb 13 2024 05:52 PM
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 into the cell I want the answer (which is a number) to be returned to (for reference use, let's say G100). When are spaces required
I am asking if the number in G13 is less than or = to 235,000. If true, let G100=G13. If false (G13>235000), let G100=235,000. What am I doing wrong?
Thank you for your help. I am somewhat a novice at the updated Excel programs and found conflicting directions in the help and online. When are spaces required?
Cindy
Feb 13 2024 06:19 PM
SolutionFeb 13 2024 06:19 PM
Solution