Thread: if function
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Harald Staff[_2_] Harald Staff[_2_] is offline
external usenet poster
  
Posts: 449
Default if function
=(MOD(A1,100)=B1)

HTH. Best wishes Harald

"john" wrote in message
...
How would i go about making a true/false where the last 2 numbers in a
cell
equal the number in another cell?

Reply With QuoteReply With Quote