Excel Help Microsoft 365

New Contributor

Hello Community!  I need some help.  I do not know what formula to use or worse once I figure it out, not sure how to use it.  I have and idea on my company quote sheet I am working on.  I have cell B6 simply mirroring the total from cell F6.  What I would like help with if possible is a way to make it to where if the the total in cell F6 and B6 are less then $250, then cell B6 will automatically populate to $250.  I am not sure if that is a IF, OR, ROUND, etc.  I am still learning and at a novice level very much still.  Please help/educate me on what the route and how to make this happen.  Thank you all in advance and I look forward to learning from this community.

2 Replies


Hello! You've posted your question in the Tech Community Discussion space, which is intended for discussion around the Tech Community website itself, not product questions. I'm moving your question to the Excel space - please post Excel questions here in the future.