IF

T

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.
 
M

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
 
T

Tufail

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

Mike H said:
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
 
T

Tufail

it's working ! thank you very much.

Mike H said:
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top