Adjust cell format accordingly for decimal places and use this formula.
=IF(B2<A2,-B2/A2,(B2-A2)/B2)
Adjust cell format accordingly for decimal places and use this formula.
=IF(B2<A2,-B2/A2,(B2-A2)/B2)
Janos S. Vamos
Data Systems Technician/Fire Controlman PO1(SW/AW)
US Navy Retired
Remember, Record Macro can be your friend for figuring out solutions.
Good or Bad, let me know how I did by clicking on the "Add Reputation" * just to the lower left of here. it only takes a few seconds to let someone know.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks