![]() |
|
|
|
#1
|
|||
|
|||
|
=min(7.5,b2+$g$3) |
|
#2
|
|||
|
|||
|
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 |
|
|
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 |