Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
formula
I need to know if I can get a formula for the following:
If cell E14 is "y" and G14 is less than or equal to 14 the H14 should be "y" |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
formula
Hi,
in H14 enter if(and(E14="Y",G14<=14),"Y","") In the case you have other values in E14 and G14 it will enter a blank if you want other thing like an N enter replace "" in the formula with "N" if this helps please click yes thanks "Help with cell function" wrote: I need to know if I can get a formula for the following: If cell E14 is "y" and G14 is less than or equal to 14 the H14 should be "y" |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
formula
In H14
=IF(AND(E14="Y",G14<=14),"","Y") That's the same answer as for your earlier post... "Help with cell function" wrote: I need to know if I can get a formula for the following: If cell E14 is "y" and G14 is less than or equal to 14 the H14 should be "y" |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
formula
Help with cell function;456786 Wrote: I need to know if I can get a formula for the following: If cell E14 is "y" and G14 is less than or equal to 14 the H14 should be "y" Try this formula in H14 =IF(AND(E14="y",G14<=14),"y","") -- barry houdini ------------------------------------------------------------------------ barry houdini's Profile: http://www.thecodecage.com/forumz/member.php?userid=72 View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=126434 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
formula
Try this:
=IF(AND(E14="y",G14<"",G14<=14),"y","") -- Biff Microsoft Excel MVP "Help with cell function" wrote in message ... I need to know if I can get a formula for the following: If cell E14 is "y" and G14 is less than or equal to 14 the H14 should be "y" |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|