how to link this dbl if statement

[Ed D]

I would like to properly write the following formula:
=if(b2=37%,33%,if(b2<>37%,b2-2%)

In english this means if b2 is equal to 37% then I want my answer in b3 to
be 33%. However if b2 is not equal to 37% then what ever is in b2 i want b3
to be 2% less.

Thanks in advance.

Ed

 

[Govind]

Hi,

use

=if(b2=37%,33%,b2-2%)

The second if condition (if(b2<>37%) is not required as the formula will
go to the second condition only if b2 is not equal to 37.

REgards

Govind.