How do I update the following formula if AL48=00, then answer will be 08 not -02
=TEXT(AL48-2,"00")
How do I update the following formula if AL49=00, then answer will be 09
not -01
=TEXT(AL49-1,"00")
Also, if AL48=01 and =TEXT(AL48-2,"00") is used, then the answer is 09, not -01
=TEXT(AL48-2,"00")
How do I update the following formula if AL49=00, then answer will be 09
not -01
=TEXT(AL49-1,"00")
Also, if AL48=01 and =TEXT(AL48-2,"00") is used, then the answer is 09, not -01