IF Formula's

Closed
Aimee - Jul 20, 2009 at 08:29 AM
venkat1926 Posts 1864 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Jul 20, 2009 at 08:33 PM
Hello,

I am trying to make a cell (lets call this A1) that does the following. I have a drop down box (lets call this B1) the choices for the drop down box are YES or NO. I want to say, If B1 = YES then A1 needs to = sum of C1 + D1, But if B1 = NO I want A1 to = C1 + D1 divided by X.

Any advise on whether this is possible?

1 reply

venkat1926 Posts 1864 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 810
Jul 20, 2009 at 08:33 PM
type in A1 this formula

=IF(B1="yes",C1+D1,(C1+D1)/x)

I suppose x is a number.
0