ExcelBanter - If formula = Nothing nothing

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - If formula = Nothing nothing (https://www.excelbanter.com/excel-discussion-misc-queries/178823-if-formula-%3D-nothing-nothing.html)

Wanna Learn

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

PCLIVE

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

Mike H

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

All times are GMT +1. The time now is 06:02 AM.