Forum Discussion
Solved
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 ...
- Hi 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 ?
I just tried it and it worked perfectly! Many thanks!
