If formula = Nothing nothing

[Wanna Learn]

Hello Here is my formula =IF(B28="Master Agreement","Master Agreement is
valid for 3 years .","Blanket Agreement is for 1 year period. "). how do I
correct the formula so that if B28 is blank nothing shows. thanks

 

[PCLIVE]

One way:

=IF(B28="","",IF("Master Agreement","Master Agreement is valid for 3 years
..","Blanket Agreement is for 1 year period. "))

HTH,
Paul

 

[Mike H]

Try this

=IF(B28="Master Agreement","Master Agreement is valid for 3 years .","")

Mike