Previous Topic Next Topic

IF Formula's

Closed
Aimee - 20 Jul 2009 à 08:29
venkat1926 Posts 1863 Registration date Sunday 14 June 2009 Status Contributor Last seen 7 August 2021 - 20 Jul 2009 à 20:33
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 response

Réponse 1 / 1
venkat1926 Posts 1863 Registration date Sunday 14 June 2009 Status Contributor Last seen 7 August 2021 811
20 Jul 2009 à 20:33
type in A1 this formula

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

I suppose x is a number.