#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
=min(7.5,b2+$g$3)
|
#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) Finally, I appreciate your help Thank you |
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 |
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 |