The IF Statement

Microsoft Excel 2007
July 27, 2009 at 11:50:19
Specs: Windows XP SP3, 992MB
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?!?!

See More: The IF Statement

Report •


#1
July 27, 2009 at 12:43:21
Excel questions belong in the 'Office Software' forum.

Report •

#2
July 28, 2009 at 06:08:31
See above, but syntax is:

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


Report •

Related Solutions


Ask Question