Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need help Coding my cells correctly-3 comparisons to be made
Greetings,
I only want to utilize four cells for this operation (in a single line in this case line 4), I will want to use it throughout the worksheet but I'm trying not to sprawl into any more cell usage. Hers's the idea...to get these four cells to accomodate the following, I keep having problems with my second condition being met and the cells staying blank until some data is entered. It's not neccessary but it would be helpful if the cells appear blank until some data has been actually entered and not like its trying to compute the blank cells. First a comparsion would be made If C4 = D4 then cell E4 displays "Equal" and cell F4 displays "Amount" If this condition does not occur then 2 more comparisons will occur... If C4 < D4 then D4-C4 and the result goes into cell E4 and cell F4 is blank Else, C4 D4 then C4-D4 and result goes into cell F4 and cell E4 is blank Thanks -- jgbadingerjr |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need help Coding my cells correctly-3 comparisons to be made
Enter this in E4:
=IF(C4=D4,"Equal",IF(C4<D4,D4-C4,"")) Enter this in F4: =IF(C4=D4,"Amount",IF(C4D4,C4-D4,"")) -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "jgbadingerjr" wrote in message ... Greetings, I only want to utilize four cells for this operation (in a single line in this case line 4), I will want to use it throughout the worksheet but I'm trying not to sprawl into any more cell usage. Hers's the idea...to get these four cells to accomodate the following, I keep having problems with my second condition being met and the cells staying blank until some data is entered. It's not neccessary but it would be helpful if the cells appear blank until some data has been actually entered and not like its trying to compute the blank cells. First a comparsion would be made If C4 = D4 then cell E4 displays "Equal" and cell F4 displays "Amount" If this condition does not occur then 2 more comparisons will occur... If C4 < D4 then D4-C4 and the result goes into cell E4 and cell F4 is blank Else, C4 D4 then C4-D4 and result goes into cell F4 and cell E4 is blank Thanks -- jgbadingerjr |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need help Coding my cells correctly-3 comparisons to be made
One way ..
In E4: =IF(COUNTBLANK(C4:D4)=2,"",IF(C4<D4,D4-C4,IF(C4=D4,"Equal",""))) In F4: =IF(COUNTBLANK(C4:D4)=2,"",IF(C4D4,C4-D4,IF(C4=D4,"Amount",""))) Select E4:F4, copy down -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "jgbadingerjr" wrote: Greetings, I only want to utilize four cells for this operation (in a single line in this case line 4), I will want to use it throughout the worksheet but I'm trying not to sprawl into any more cell usage. Hers's the idea...to get these four cells to accomodate the following, I keep having problems with my second condition being met and the cells staying blank until some data is entered. It's not neccessary but it would be helpful if the cells appear blank until some data has been actually entered and not like its trying to compute the blank cells. First a comparsion would be made If C4 = D4 then cell E4 displays "Equal" and cell F4 displays "Amount" If this condition does not occur then 2 more comparisons will occur... If C4 < D4 then D4-C4 and the result goes into cell E4 and cell F4 is blank Else, C4 D4 then C4-D4 and result goes into cell F4 and cell E4 is blank Thanks -- jgbadingerjr |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need help Coding my cells correctly-3 comparisons to be made
thanx big help ^^
-- jgbadingerjr "jgbadingerjr" wrote: Greetings, I only want to utilize four cells for this operation (in a single line in this case line 4), I will want to use it throughout the worksheet but I'm trying not to sprawl into any more cell usage. Hers's the idea...to get these four cells to accomodate the following, I keep having problems with my second condition being met and the cells staying blank until some data is entered. It's not neccessary but it would be helpful if the cells appear blank until some data has been actually entered and not like its trying to compute the blank cells. First a comparsion would be made If C4 = D4 then cell E4 displays "Equal" and cell F4 displays "Amount" If this condition does not occur then 2 more comparisons will occur... If C4 < D4 then D4-C4 and the result goes into cell E4 and cell F4 is blank Else, C4 D4 then C4-D4 and result goes into cell F4 and cell E4 is blank Thanks -- jgbadingerjr |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Color coding cells | Excel Discussion (Misc queries) | |||
Color Coding Cells | Excel Worksheet Functions | |||
Can an array be made of discontinuous cells of the same row? | Excel Discussion (Misc queries) | |||
Will excel add cells using colour coding eg Add all red cells | Excel Discussion (Misc queries) | |||
Color coding cells in Excel | Excel Discussion (Misc queries) |