Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 04-25-2022, 08:43 AM
laith93 laith93 is offline Add certain value to another value if match a rule Windows 10 Add certain value to another value if match a rule Office 2019
Competent Performer
Add certain value to another value if match a rule
 
Join Date: Jul 2021
Posts: 117
laith93 is on a distinguished road
Default Add certain value to another value if match a rule

Hi,
Look at this image (attachment demo file)


13.png

I want to add 2.5 to all values in column C1 if the value is lower than 7.4, but at the same time, the result must not exceed 7.5 as it is the upper limit
In more detail, if I add 2.5 to 6.5, it will be 9.5 which exceeds my upper limit (7.5), so 6.5 must be converted to 7.5
also when I add 2.5 to 7.4, it must be 7.5.
So how to do that with my thanks
Attached Files
File Type: xlsx demo.xlsx (10.0 KB, 5 views)
Reply With Quote
  #2  
Old 04-25-2022, 10:05 AM
xor xor is offline Add certain value to another value if match a rule Windows 10 Add certain value to another value if match a rule Office 2016
Expert
 
Join Date: Oct 2015
Posts: 1,097
xor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to all
Default

=min(7.5,b2+$g$3)
Reply With Quote
  #3  
Old 04-25-2022, 11:23 AM
laith93 laith93 is offline Add certain value to another value if match a rule Windows 10 Add certain value to another value if match a rule Office 2019
Competent Performer
Add certain value to another value if match a rule
 
Join Date: Jul 2021
Posts: 117
laith93 is on a distinguished road
Default

Quote:
Originally Posted by xor View Post
=min(7.5,b2+$g$3)
Thank you so much my bro
Ok, the function works fine, but the only problem is with values that are >= 7.5, such as 8.2 in our case, the function reduces it to 7.5 also, which does not match our need, because we add 2.5 to only values which are <= 7.4, so any values >= 7.5 must not affected by this process

However, I modified your function to be as
Code:
=IF(B2<=7.4,MIN(7.5,B2+$G$3),B2)
which fulfills our need.

Finally, I appreciate your help
Thank you
Reply With Quote
Reply

Tags
excel 2019, rules, sumif columns

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Rule to forward email using rule to me@onenote.com anony1 OneNote 2 02-04-2023 02:39 PM
Able to set up delegate meeting folders rule but cannot create an effective rule for my own meetings kottman Outlook 0 03-08-2019 12:48 PM
Excel - Index and Match Function ,First Second and Third Match paulzy95 Excel 10 09-29-2016 10:46 PM
Add certain value to another value if match a rule Outlook rule to not send if attachment name doesn't match criteria SerenityNetworks Outlook 10 03-20-2016 10:56 AM
Rule to turn off a rule tiger10012 Outlook 2 02-23-2013 09:50 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:36 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft