Need help Coding my cells correctly-3 comparisons to be made

G

Guest

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
 
R

Ragdyer

Enter this in E4:
=IF(C4=D4,"Equal",IF(C4<D4,D4-C4,""))

Enter this in F4:
=IF(C4=D4,"Amount",IF(C4>D4,C4-D4,""))
 
G

Guest

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(C4>D4,C4-D4,IF(C4=D4,"Amount","")))

Select E4:F4, copy down
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Transfer data from a cell to another workbook if certain criteria 14
Macro to remove contents of cell and move all other contents up one row 1
Chart to display only bars for values that are > 3 & blank cells 1
Need cells to show as zero or empty 3
Another Conditional Formating. NEED ANSWER TO FINISH PROJECT! 1
HELP! Nesting IF Statements/Dependent Dropdown List 4
Data Entry - Write to next cell 3
Excel Macro Problem Copy Data from sheet1 to 2 but into different cells 5

Top