Calc cell based on contents of another cell

[MOSBEIUK]

Formula Excel.jpg

What I am trying to do is an IF OR scenario, where IF cell G5 has 33% then Cell H5 will show the results for 33% of F5 which is the total value.

Anyone business minded will know im trying to work out a weighted forcast, where my sales team need not worry about mathatics but simply enter their data and voila the results will always be correct and clear for me to access.

[rcm]

Could you send an excel sample so it can be fitted with the formula?

[FDibbins]

Hi and welcome to the forum

Please take a moment to read the forum rules and then amend your thread title to something descriptive of your problem (think google search terms?). Once you have done this please send me a PM and I will remove this request. (Also, include a link to your thread - copy from the address bar)

To change a Title on your post, click EDIT POST then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

[MOSBEIUK]

Could you send an excel sample so it can be fitted with the formula?

Thanks for the reply, how would I send the sample please. Sorry am a newbie here.

[FDibbins]

IF cell G5 has 33% then Cell H5 will show the results for 33% of F5 which is the total value

Maybe this?
H5=G5*F5

[MOSBEIUK]

Dibbins your so smart! or am I so silly. =SUM(F6*G6)

Look at me over complicating things!

[FDibbins]

You would only use the SUM() function if you are going to add a range of cells together, otherwise just reference the cells directly