Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Confirm target cell is equal
A1 = 100
B1+C1 = 100 If B1+C1 = 100 less or more than A1 what should I include in the formula? Or Conditional Formatting be a better way? Thank you for any an all help. Pat |
#2
|
|||
|
|||
Hi
not really sure what you're trying to do.< Do you mean =IF(B1+C1=A1,"Equal","not equal") -- Regards Frank Kabel Frankfurt, Germany "Pat" schrieb im Newsbeitrag ... A1 = 100 B1+C1 = 100 If B1+C1 = 100 less or more than A1 what should I include in the formula? Or Conditional Formatting be a better way? Thank you for any an all help. Pat |
#3
|
|||
|
|||
That will do just nicely Frank, thanks.
Cheers "Frank Kabel" wrote in message ... Hi not really sure what you're trying to do.< Do you mean =IF(B1+C1=A1,"Equal","not equal") -- Regards Frank Kabel Frankfurt, Germany "Pat" schrieb im Newsbeitrag ... A1 = 100 B1+C1 = 100 If B1+C1 = 100 less or more than A1 what should I include in the formula? Or Conditional Formatting be a better way? Thank you for any an all help. Pat |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Maintaining cell reference after sorting | Excel Discussion (Misc queries) | |||
Using Jet to read excel file returns blank for last cell - sometim | Excel Discussion (Misc queries) | |||
Display actual contents of cell | Excel Discussion (Misc queries) | |||
copy a cell value not its function | Excel Discussion (Misc queries) | |||
Transferring cell content between workbooks using cell references | Excel Discussion (Misc queries) |