Add certain value to another value if match a rule

laith93 · #3 04-25-2022, 11:23 AM

Quote:

Originally Posted by xor

=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

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