Excel Gurus Help: Nested IF

[coolmunda]

Re: Excel Gurus Help: Nested IF

@Umar_Talib

well - in the spreadsheet that you uploaded… it was stored as text…

this happens usually when you copy paste the table from a word processor. There’s a subtle difference between “format” as number and “store/treat” as number.

Are you sure? When I checked it was number. Anyway, khair brother, you’ve made my life much easier.