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
December 20, 2019
December 7, 2016
If you have Excel 2016 or newer you can use the IFS function.
If you are using an older version then you can use nested IF function.
Depending on how you have organized your data it might be better to lookup using INDEX and MATCH.
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.