Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 ? 🙂
Hi Nilesh,
You can use your requirement in the following way:
if(DISCOUNT<1,(1-DISCOUNT),
if(DISCOUNT=1,<Enter the Expression You Want>))
Hi Nilesh,
You can use your requirement in the following way:
if(DISCOUNT<1,(1-DISCOUNT),
if(DISCOUNT=1,<Enter the Expression You Want>))
Thank you! it worked!