
New Member

March 3, 2020

Please see below, I am trying to put the value "65", multiplied by £45 into the cell adjacent to the result "true" because it is in the range 30 to 90
Total hours 65.0
£35 per hour, for over 180 hours FALSE
£40 per hour, for over 90 hours FALSE
£45 per hour, for over 30 hours TRUE
£50 per hour, for up to 30 hours FALSE


Trusted Members

December 20, 2019


VIP

Trusted Members

December 7, 2016

Hello Dean,
If you have Excel 2016 or newer you can use the IFS function.
https://www.myonlinetraininghu.....s-function
If you are using an older version then you can use nested IF function.
https://www.myonlinetraininghu.....-explained
Depending on how you have organized your data it might be better to lookup using INDEX and MATCH.
https://www.myonlinetraininghu.....-functions
Power Query is also a good tool to use, but not necesarrily the best option if you have small amount of data to work with.
If you need more help with this then please upload a sample file, as suggested by Purfleet.
1 Guest(s)
