Forum

Notifications
Clear all

Using value from a range

3 Posts
3 Users
0 Reactions
76 Views
(@macdvt1)
Posts: 1
New Member
Topic starter
 

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

 
Posted : 04/03/2020 3:51 am
(@purfleet)
Posts: 412
Reputable Member
 

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 

 
Posted : 04/03/2020 6:02 am
Anders Sehlstedt
(@sehlsan)
Posts: 972
Prominent Member
 

Hello Dean,

If you have Excel 2016 or newer you can use the IFS function.
https://www.myonlinetraininghub.com/excel-ifs-function

If you are using an older version then you can use nested IF function.
https://www.myonlinetraininghub.com/excel-nested-ifs-explained

Depending on how you have organized your data it might be better to lookup using INDEX and MATCH.
https://www.myonlinetraininghub.com/excel-index-and-match-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.

 
Posted : 04/03/2020 5:23 pm
Share: