Log In
Register
Home
New Member
March 3, 2020
Offline
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
Offline
Sorry can you clarify what you actually want to happen and based on what figure?
it is always best to upload an example worksheet so we can see how the data is formatted
Purfleet
VIP
Trusted Members
December 7, 2016
Offline
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)
