Computing.Net > Forums > Windows XP > The IF Statement

Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.

The IF Statement

Reply to Message Icon

Name: KatDRAZA
Date: July 27, 2009 at 11:50:19 Pacific
OS: Windows XP SP3
CPU/Ram: 992MB
Product: Microsoft Excel 2007
Subcategory: General
Comment:

I'm trying to figure out the IF statement on Excel. I can't seem to figure out how to return something other then a text result. I need to input another formula.
I have the Logical_test as f5>200 and I want, if it's true, to multiply the number in cell f5 by 4.1 and if it's false to multiply it by 4.4!! How in the world do I write it?!?!



Sponsored Link
Ads by Google

Response Number 1
Name: aegis1
Date: July 27, 2009 at 12:43:21 Pacific
Reply:

Excel questions belong in the 'Office Software' forum.


0

Response Number 2
Name: jon_k
Date: July 28, 2009 at 06:08:31 Pacific
Reply:

See above, but syntax is:

=IF(F5>200,F5*4.1,F5*4.4)


0

Sponsored Link
Ads by Google
Reply to Message Icon

Related Posts

See More







Post Locked

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


Go to Windows XP Forum Home


Sponsored links

Ads by Google


Results for: The IF Statement

Writing a IF statement www.computing.net/answers/windows-xp/writing-a-if-statement/174497.html

if statement excel www.computing.net/answers/windows-xp/if-statement-excel/95823.html

Batch file help needed... www.computing.net/answers/windows-xp/batch-file-help-needed/163063.html