@TERY1680
Formula suggestions without guarantee:
If in A1 and in B1 are the two different scenarios and you want the highest value to appear then...
=IF(A1<B1,A1,B1).
or
=MAX(A1,B1)
With your permission, I recommend to provide more information.
You'll get a quicker and more accurate answer, and those who want to help don't have to invest time guessing the problem.
If possible, add a file (without sensitive data) and use this file to describe your project step by step, or add photos with the appropriate description.
Please, Always inform about your Excel version, operating system, storage medium/hard drive, OneDrive, Sharepoint, etc.).
Don't forget that not every Excel user has a clue about every job and what you see he can't see.
In this link you will find some more information about it:
Welcome to your Excel discussion space!
Hope I was able to help you with this information.
NikolinoDE
I know I don't know anything (Socrates)
