Corporate_DGNR8
New Member
- Joined
- Jun 27, 2022
- Messages
- 2
- Office Version
- 365
- Platform
- Windows
Hi All,
Just after some help, I’m trying to design a simple as possible settlement matrix, so that two values are put into a spreadsheet I.e value to pay and agreed settlement and a percentage is returned.
That’s done, what I’m struggling to make work is based on the returned percentage in a cell reference is the below.
If it’s over 80% to return the word “Accept”
Under 80% but above 50% “Refer to Manager”
Under 50% “Automatic Decline”
*I’ve got a percentage and word array pre-setup in another tan from 100% to 0%, if that helps.
And because I haven’t written one of these for a long while, I’m lost and could use some guru advice please
Thanks
D
Just after some help, I’m trying to design a simple as possible settlement matrix, so that two values are put into a spreadsheet I.e value to pay and agreed settlement and a percentage is returned.
That’s done, what I’m struggling to make work is based on the returned percentage in a cell reference is the below.
If it’s over 80% to return the word “Accept”
Under 80% but above 50% “Refer to Manager”
Under 50% “Automatic Decline”
*I’ve got a percentage and word array pre-setup in another tan from 100% to 0%, if that helps.
And because I haven’t written one of these for a long while, I’m lost and could use some guru advice please
Thanks
D