IF

[Tufail]

hello,
B1 has value, C1 has exchange rate and some time doesn't have so that's why
I am using following formula:
=B1/IF(C1=0,1,C1) "my formula cell is D1"

now what i want that if A1=JMD, B1=any numeric value, C1=any rate, then want
apply exchange rate, and if A1=USD, B1=any numeric value, C1=any rate, then
need as is value of B1 in D1, i means if A1=USD then don't want apply formula
or exchange rate.

 

[Mike H]

Hi,

As described there are several conditions that you logic will not trap. For
example what if A1 is blank. For those conditions this formula returns
'Unspecified'.

=IF(AND(A1="JMD",ISNUMBER(B1+C1)),B1*C1,IF(A1="USD",B1,"Unspecified"))


Mike

 

[Tufail]

oh sorry, A1 must has always either JMD or USD.

Hi,

As described there are several conditions that you logic will not trap. For
example what if A1 is blank. For those conditions this formula returns
'Unspecified'.

=IF(AND(A1="JMD",ISNUMBER(B1+C1)),B1*C1,IF(A1="USD",B1,"Unspecified"))


Mike

 

[Tufail]

it's working ! thank you very much.

Hi,

As described there are several conditions that you logic will not trap. For
example what if A1 is blank. For those conditions this formula returns
'Unspecified'.

=IF(AND(A1="JMD",ISNUMBER(B1+C1)),B1*C1,IF(A1="USD",B1,"Unspecified"))


Mike

 

[Mike H]

I'm pleased that worked, thanks for the feedback.

Mike