Security & Virus | Hardware | Windows XP | Windows Vista | PC Gaming

excel formula help

Comment:

Hi im stuck on what i think should be a simple formula all i want is for cell B1 to show 200 if cell A1 is 75 or higher but show 0 if less than 75 any help would be apreciated

Name: Jennifer SUMN
Date: February 11, 2009 at 06:15:22 Pacific

Reply:

=IF(A1<75,0,200) OR =IF(A1>74,200,0) "So won’t you give this man his wings What a shame To have to beg you to see We’re not all the same What a shame" - Shinedown

0

DOS Conflict with softwar...

exchange server

Post Locked

This post is quite old and has been locked from receiving new replies. Please create a new posting instead.

Summary: Hi All I need some help with a certain Excel formula. Hopefully my explanation is clear enough. Basically I have 3 columns - Days, Hours and Minutes. Currently I put in data for each column and it is ...

Summary: Grok, I agree and have looked into it's use many failed times. I must have some kind of mental block for it. I just finished analyzing your formula in regards to Tony's query for the purpose of under...

Summary: Hey, I am working on a quick spreadsheet for reporting for work, and everything works fine, except for 1 sheet, which i'm not sure how to do it! I'm not very advanced at excel, but i have been using V...