Question:

Unless Function in Excel?

by  |  earlier

0 LIKES UnLike

In excel i have the formula [=IF('Input Results'!O18=0,1,0)] is there a way that i can change this so that it is =IF('Input Results'!O18=0,1,0) Unless 'Input Results' has no data?

 Tags:

   Report
Answer The Question I've Same Question Too

1 ANSWERS

Sort By: Date  |  Rating

  1. You probably want the ISBLANK function:

    =IF(ISBLANK('Input Results'!O18),"Your Message HERE",IF('Input Results'!O18=0,1,0))

    or something like that

You're reading: Unless Function in Excel?

Question Stats

Latest activity: earlier.
This question has 1 answers.

BECOME A GUIDE

Share your knowledge and help people by answering questions.
Register Now