Forum Discussion
dmarshall32
Nov 13, 2021Copper Contributor
Excel Help Microsoft 365
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.
- Do you have a location based policy in effect? If so, I would say yes that is your issue and not aware of another way around it.
4 Replies
Sort By
- RecalcOrDieIron ContributorHi Darnell,
In reading your requirement, I think the basic formula you're looking is:
= IF( F6 < 250, 250, F6 )
Now I am bit confused, when you say: "...if the the total in cell F6 and B6 are less then $250, then cell B6 will automatically populate to $250." Are you requiring that F6 and B6 have to be summed up and also check if this operation is under 250 as well ?- dmarshall32Copper ContributorThank you for the response Microsoft_Excel_Recalc_Or_Die. No. I simply wanted B6 to = the total of F6. But I did not want it to reflect the true value of F6 if it was less then $250. I wanted to capture the data (miles), but not have the price ever go less then $250 on the quote side of the sheet.
- dmarshall32Copper ContributorI just tried it and it worked perfectly! Many thanks!