Solved net if and and function

March 28, 2012 at 08:36:42
Specs: Windows XP
If A1=0120 then B1 should be equal to 12. If any other number then it is false

How can I do a IF function on this?

Thanks,


See More: net if and and function

Report •


#1
March 28, 2012 at 09:12:32
Try:


=IF(A1=0120,12,"False")

MIKE

http://www.skeptic.com/


Report •

#2
March 28, 2012 at 09:21:33
✔ Best Answer
Mike's suggestion will return False as a text string.

This formula will return the logical FALSE as in TRUE or FALSE.

=IF(A1=0120,12)

Depending on what you plan to do with the resut, one or the other might work better for you.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •

#3
March 28, 2012 at 09:36:02
Thank you both on your prompt responses. Both works for me! :)

Report •
Related Solutions


Ask Question