True/false statement help

  • Thread starter Thread starter toonmadfan
  • Start date Start date
T

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
 
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.
 
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
 
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
 
Back
Top