Divide but keep minimum value

[adflamm7]

Hello, I am dividing a cell by a set value in excel, but I would like to return 1 if the results are 0 or <1. I'm having trouble writing the formula correctly. This seems pretty simple, but I am goofing. I have tried If functions.

Thank You for your time.

 

[Fluff]

Something like
=max(1,yourformula)

 

[adflamm7]

Ha, that worked perfectly. I knew it was easy and I was being a bonehead. Thank you so much! I wish I could help people on these boards as much as I've been helped

 

[Fluff]

You're welcome & thanks for the feedback.