=(C5-B5)/ABS(B5)
This is my formula...right now I am getting the div/o result...what do I need to do to get it to be blank until data is put in the cells that would make it calculate an actual percentage...
=(C5-B5)/ABS(B5)
This is my formula...right now I am getting the div/o result...what do I need to do to get it to be blank until data is put in the cells that would make it calculate an actual percentage...
This is a duplicate post. See the answers in your other posting.
Regards
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.
Thread Closed.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks