Can anyone please help with this excel question too?

I have a whole heap of fomulas, example... A = B + C...

.. now if B + C has no text then I have a '0' everywhere, or many of them all over the page.

How do I stop these from appearing so that a number appears only when numbers are entered into the columns I am adding up?

Phew.. that was confusing :)

Look at the fist cell that is referenced example in cel D1 we have a formula

=(A1+C1)/100
change it to this

=(If A1="","",(A1+C1)/100

to explain what it is doing

If A1 = nothing , then nothing , otherwise perform the formula

Or.. options.. tick 'Hide zero values'.

I just found that one!

yeh, but not real useful p76 when zeros are a required value within your spreadsheet, not recommended in other words

Good Morning Excel Champs,

Is it possible to have more than one IF?

What I want to do is look at 3 columns and IF they meet requirements I then perform a formula on a fourth column.

Is this where AND comes into the formula setup?

Thanks
Twodogs

I am thinking I know the answer to this one... I think you can have up to 7 IF's.. tho the gurus will know for sure

You can have as many as seven IF's in any single formula. The AND can be used in conjunction with IF to test if two variables are met.

Here is one that I use in one of my programs:
=IF(AND(85<=Q4,Q5<=75),"A",IF(Q6<=75,"B",IF(AND(75>=Q6,Q7<=65),"C","D")))

=IF(AND(O7<2.5,Q7<35.2,U7>0),1,0)

I just tried the above formula but although the three columns meet criteria I still get 0 rather than a 1

Have I balls up somewhere?

Twodogs

Don't worry I just tried it again now it works. Beats me I didn't change anything??

Thanks guys

Twodogs

See my previous response, there is a formula shown there that I use in one of my programs.