Formula Help please......
 

How do I write the following formula in excel-

If H8 is less than 5 H27 equals F27

Formula Help please......
 

How do I write the following formula in excel-

If H8 is less than 5 H27 equals F27

If you want a zero as the return for FALSE...

=IF(H8<5,F27,0)

If you want an empty cell as the return for FALSE...

=IF(H8<5,F27,"")

Enter the formula in H27.

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion

Formula Help please......
 

Entered in H27 =IF(H8<5,F27,"not less")

Gord



On Wed, 3 Dec 2014 22:10:07 +0000, Nettie
wrote:


How do I write the following formula in excel-

If H8 is less than 5 H27 equals F27