Could someone help me with the following formula please?
Cell M1 contains formula =IF(A1<J12,(A1*100)," ")
What I need is if A1 is less than J12 then A1(*100) should show in the cell
Cell M2 contains formula =IF(OR(A1=>J12,A1<G12),a1*100," ")
If A1 is greater than or equal to J12 but less than G12 then A1(*100) should
show in the cell
Hope this makes sense â€“ it is Friday afternoon here and brain cells are
firing extremely slowly ;-))