A formula to use 1 set of calculation if yes or another if no

[TonyPepper]

Hi All,

I am trying to create a formula in a spreadsheet for a project at work and having trouble.

I like to have a choice of two different calculation depending on whether another cell has a "yes" or a ''No".

I have attached an example of what I mean.

Thanks for any help I receive.

[oeldere]

with vlookup in a table.

See the result in the green cell.

[José Augusto]

See if this solve your problem

Please Login or Register  to view this content.

[TonyPepper]

Hi oeldere,

Wow!!! thanks for your fast reply

Is there another way because I need this formula in over 60 rows and the numbers change for each row.

[José Augusto]

Try this in I6 and copy down

Please Login or Register  to view this content.

[oeldere]

g6=if($F6="yes",$H6,$J6) and drag down.

[TonyPepper]

Awesome Jose that works a treat.

Thank you both for your help.

[José Augusto]

You are welcome.

[oeldere]

You're welcome. We appreciate the feedback!

It'd also be appreciated if you were to click the add Reputation button at the foot of any of the posts of those who helped you reach a solution.