Add IF Statement to formula

[lesley burlingham]

I have basic formula, =I16+(C22*I16). I need it to return "No Information for Select" if the answer is 0

 

[Khalid NGO]

Hi Lesley,

=IF(I16+(C22*I16)=0,"No Information for Select",I16+(C22*I16))

But I suggest to use custom formats to return your message when value is zero.
Me and Narayan Sir already explained in your previous thread.

Regards,

 

[Khalid NGO]

Here is the link @NARAYANK991 explained use custom formats to avoid multiple calculations:
http://chandoo.org/forum/threads/add-if-statement-to-a-index-and-match.21521/

 

[lesley burlingham]

Thank you, I will have another ready of it. I am getting a Value message,

 

[Khalid NGO]

So can we have a sample file to see where the problem is ?

 

[lesley burlingham]

It a big file. If you change he duration in B13 and B21 itwill chang from havingvalues from sheet 3. to having 0. But for some reason which it is 0. is gives #value

 

[Khalid NGO]

Ok, can you check the result in D18
We can not +/- with text strings, i have update your formula with substitute.

You can use the same for other(s)

 

[NARAYANK991]

Hi Lesley ,

I am not able to understand what you want to do ; you have two intermediate calculations in H18 and H21 , where you have selected a font colour of WHITE so that the cell does not display anything.

These same intermediate values are used to calculate values in D18 and D21.

The formula for calculating the values in D18 and D21 can have the IF statement with the message "No information" , but why should the formulae in H18 and H21 have this ? The formula in H18 and H21 can use a value of 0 instead of a text value such as "No information" , since anyway the value in these cells is not being displayed.

Narayan