gianluigi
Member
Registered: 9th Mar 05
Location: Ipswich, Suffolk
User status: Offline
|
im using a spreadsheet where if one cell (called total) is populated, its contents are autmatically populated in another cell called payments.
i want to change it, so if the figure in the total cell is a negative, that figure is repeated in payments. however if its a positive total i want it to be populated in another cell called refunds.
what would the formula be to do this?
|
Fonz
Premium Member
Registered: 12th May 06
Location: Newbury, Berks
User status: Offline
|
you need to use the "IF" command.
i've not used it recently, used help (F1) for more info but i am sure you can use IF(cell1, 0> true, <0 false) or something along those lines??
|
