How to add 2 IF Statements together ??

[#1]

Hi Friends! A simple question this is,

How do you add 2 IF statements together?

Example :

I have 2 sets of discounts. one value is ' 0.52 ' and the other value is ' 1 ' .

My previous problem was, how do you add in this discount in a formula to change from 0.52 to 48%. this has been accomplished.

Now the problem is, how do i add in the 1 also!

because the formula i am using is,

=

if(DISCOUNT<=1,(1-DISCOUNT))

How do you add 2 If statements. so i would be like, one statement for the value '0.52', and another statement for the value '1'.

Any ideas ? 🙂

[rahulgupta · Accepted solution]

Hi Nilesh,

You can use your requirement in the following way:

if(DISCOUNT<1,(1-DISCOUNT),
 if(DISCOUNT=1,<Enter the Expression You Want>))

[#3]

Thank you! it worked!