| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
If formula = Nothing nothing
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
If formula = Nothing nothing
One way:
=IF(B28="","",IF("Master Agreement","Master Agreement is valid for 3 years ..","Blanket Agreement is for 1 year period. ")) HTH, Paul -- "Wanna Learn" wrote in message ... 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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
If formula = Nothing nothing
Try this
=IF(B28="Master Agreement","Master Agreement is valid for 3 years .","") Mike "Wanna Learn" wrote: 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
