Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #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, 7 views)
Reply With Quote
 

Tags
excel 2019, rules, sumif columns



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 08:44 AM.


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