Forum Discussion

Mr_Raj_C's avatar
Mr_Raj_C
Brass Contributor
Jan 25, 2025
Solved

Help with building a modelling tool

Dear Excel Community,   Hope you are all keeping well ?   I'm currently seeking some help in finishing off a modelling tool want to build in Excel (see attached).   Essentially, the tool is to ...
excel
  • Mr_Raj_C's avatar
    Mr_Raj_C
    Jan 26, 2025

    SergeiBaklanThank you so much. This is exactly what i was looking for.

    Just one question though, the formula's in Column C don't seem to be working in the current state but if i reverse the formula, it works. Would appreciate your thoughts as to why that could be ?

     

    Thanks


    Raj

Mr_Raj_C's avatar
Mr_Raj_C
Brass Contributor
Jan 26, 2025

SergeiBaklanThank you so much. This is exactly what i was looking for.

Just one question though, the formula's in Column C don't seem to be working in the current state but if i reverse the formula, it works. Would appreciate your thoughts as to why that could be ?

 

Thanks


Raj

SergeiBaklan's avatar
SergeiBaklan
MVP
Jan 26, 2025

Mr_Raj_C , I didn't touch formula in column C. Perhaps you meant

=$B$2*(1-B10)

Not sure what is the business logic behind.

  • Mr_Raj_C's avatar
    Mr_Raj_C
    Brass Contributor
    Jan 27, 2025

    Apologies SergeiBaklan . I wasn't trying to imply you touched the formula :)

    I had a pre written formula in the cell but i've noticed error with it. It's working now.

    Once again, thanks so much for your help

    Kind regards

    Raj

Resources