Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
yes/no - please someone help!!
I need a formular that will give "investigate" in a column when a
amount in cell c4 equal to -£50,000 or greater or +£50,000 or greater. Iam currently using this =IF(N15$E$38,"INVESTIGATE",IF(N15<$E $38,"fine",FALSE)) which doesn't seem to be working. Many thanks, Ola. |