Forum Discussion

Beeeemster's avatar
Beeeemster
Copper Contributor
May 14, 2022

Formulae / approach advice please

Hi, I wonder if you can provide some guidance?    Can excel choose a value of a cell so that some logic is true? Allow me to explain......   In my example, I want to compare the impact of an ele...
excel
Formulas and Functions
Beeeemster's avatar
Beeeemster
Copper Contributor
May 15, 2022

Thanks TomHinkle 

 

Thanks for the help.

 

My mistake - the off-peak rate should be 0.0075 i.e. 7.5 pence. I'm trying to compare having 2 time-based prices, with one flat-rate price. I'm trying to use Excel to see the number of off-peak (low-rate) hours required, in order to make the dual-rate tariff better value.

 

Tony

 

Beeeemster's avatar
Beeeemster
Copper Contributor
May 15, 2022

Hey,

 

I've been able to successfully use the Goal Seek function.

 

Thanks all for your help :O)

  • Riny_van_Eekelen's avatar
    Riny_van_Eekelen
    Platinum Contributor
    May 15, 2022

    Beeeemster Of course it's your choice to use the very manual approach of Goal Seek for this, when you can have it done automatically with the straightforward formula I provided earlier. Demonstrated in the attached file.

Resources