If formula = Nothing nothing

W

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
 
P

PCLIVE

One way:

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

HTH,
Paul
 
M

Mike H

Try this

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

Mike
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

dropdown unhide sheet 3
hide code does not hide 2
if the date 1
Please Help! 7
Avoiding #N/A 4
Help with formula 7
Commission formula 6
Formula Adjustment 4

Top