True/false statement help

[toonmadfan]

Hi all

just after a quick fix (and probably a very simple one too, lol)

I want a cell to display 0 if a different cell is less than a given
value (in this case 95). One of the issues i face is that the cell i
want to display as 0 (in the above instance) is needing a calculation
in there.

b4 = the cell which will determine the outcome, less than 95=0 in cell
b10
b5 = value
b9 = value
b10 = b5+b9 currently (but should display 0 if b4 is less than 95)

All help appreciated

yY

 

[Don Guillett]

Did you look in the help index for IF?
in b10
=if(b4<95,0,b5+b9)

 

[RagDyer]

What was wrong with the suggestions that you received in the misc. group 4½
hours ago?

Please don't multipost.

As you can see, you're wasting people's time with duplicate suggestions.

 

[Bob I]

Please don't multi-post, you have replies at your other posting of 5
hours ago.

 

[yopyop]

Hello again

firstly, let me tell you that i'm new to the newsgroup here (i signed
up this afternoon as i thought i may get some help) and i'm having
some difficulty in finding the post from earlier on? I'm assuming
that one of you has deleted it? I wouldn't have posted again if i had
seen my original post or read any responses. I did check earlier at
work as well as again when i got home.

Don, thanks for your help. The formula worked fine. I think even if
i had have checked the index for it, i wouldn't have been able to put
that together, I'm an excel novice, lol (but i've learned another
function thanks to you

Cheers
yY

 

[AltaEgo]

Your message and answers still exist: If you cannot find it, you can search
the Microsoft newsgroups site. Hear is the result of a search on your
subject heading

http://www.microsoft.com/communitie...&pt=&catlist=&dglist=&ptlist=&exp=&sloc=en-us

You will learn to appreciate Excel more as you learn. Google is a great
resource but, if you are stuck, don't hesitate to ask to ask questions.
There are many people happy to help.

As a newbie, you may gain some benefit from reading "Suggestions For Proper
NewsGroup Usage" on the following link

http://www.cpearson.com/excel/HintsAndTipsForNewsgroupUsers.aspx