formula find isnumber

  1. R

    What formula works for this

    I need to create a formula to solve this question (put in plain english) so I ask Excel: Look for x in the following cells AI89:AM94 and if you find x put an x otherwise put a 1 if you can only find numbers Any help is greatly appreciated.

Some videos you may like

This Week's Hot Topics