Add a condition to a formula

[Brew]

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

 

[ken2step]

=if(AL48="00","08",Text(AL48-2,"00"))

is this what you want?
ken

 

[Aladin Akyurek]

=TEXT(AL48-IF(N(AL48),2,0),"00")

Same setup for AL49 with 2 replaced with 1.

 

[Brew]

Thanks Ken2step , but
How do I include 01 in this formula also?
01 would equal 09, while 00 equal 08

 

[fairwinds]

Maybe something like this ?

=TEXT((A1 < A2)*10+A1-A2,"00")

 

[Brew]

The following formula meets all of my conditions, unless Al49 is 00 or 01
=TEXT(AL49-1,"00") .

2 less than 00=08
1 less than 00=09

2less than 01=09
1 less than 01=00

Therefore, show me how do I add
=if(AL49="00","08",Text(AL49-2,"00")) or if Al49=01 then, 09

 

[Brew]

I figured this one out. It's the following formula:
=IF(AL48="00","08",IF(AL48="01","09",TEXT(AL48-2,"00")))
Thanks for your help

 

[fairwinds]

=TEXT((AL49 < 2)*10+AL49-2,"00")

 

[Brew]

How do I fix this formula to meet my conditions:

=IF(AL48="00","08",TEXT(AL48-2,"00"))or IF(AL48="01","09",TEXT(AL48-2,"01"))

 

[fairwinds]

Try the formula I posted twice now