![]() |
#1
|
|||
|
|||
![]()
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 |
Tags |
excel 2019, rules, sumif columns |
|
![]() |
||||
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 |
![]() |
SerenityNetworks | Outlook | 10 | 03-20-2016 10:56 AM |
Rule to turn off a rule | tiger10012 | Outlook | 2 | 02-23-2013 09:50 AM |