Excel Help. IF statements.

PostExcel Help. IF statements. by **Emily_Belle** » Thu Oct 29, 2009 7:15 pm

Said id help someone with a spreadsheet.

see the current formula in the highlighted cell how do i make it do all that stuff. but only if the C Column is Yes.

basically IF C = Yes ,then do Formula. If C = No, dont do formula.

Can anyone help. know the precise code for Excel?

Additional.

Want it to do a diff formula if box says no..

Cheers again..

You'd type into the cell =if(x,y,z)

Where x is the logical condition, y is what to do if its true and z is what to do when it's false.

PostRe: Excel Help. IF statements. by **Trinity** » Thu Oct 29, 2009 8:04 pm

I tend to keep my formulae seperate from the if statements. I'd have both formulae run in hidden columns and then reference the result as required ie

Cell A1 (hidden) - C1*.5
Cell B1 (hidden) - D1*.5

Cell E1 =if(x,A1,B1)

Where x is the logical condition, A1 is the result of one formula, B1 being the other. This gives you the option to see both formulae rather than having to rely on a change of condition.

PostRe: Excel Help. IF statements. by **Potterton** » Thu Oct 29, 2009 11:51 pm

This should work:

=IF(C2="Yes",A,B)

Where 'A' is your formula for 'Yes' and 'B' is the formula if it's anything else.

The only problem is it will do 'B' even if it doesn't say specifically 'No'. You could make it so it checks that as well by adding another if:

=IF(C1="Yes",A,IF(C1="No",B,""))

Hope that helps.

Excel Help. IF statements.

Who is online

Affiliates