| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Formula Help please......
How do I write the following formula in excel-
If H8 is less than 5 H27 equals F27 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula autofill to cells below – formula arguments are cell areas in different columns | Excel Discussion (Misc queries) | |||
| Regression Leverage Formula (Jerry W. Lewis or Mike Middleton)already have DFITS formula | Excel Worksheet Functions | |||
| Formula expected end of statement error, typing formula into cell as part of VBA macro | Excel Programming | |||
| Cell doesn't show formula result - it shows formula (CTRL + ' doe. | Excel Worksheet Functions | |||
| Commenting custom formula fields/formula on formula editor | Excel Programming | |||
Linear Mode
