LinkBack URL
About LinkBacks
If A is larger than B, Then do A/B * 100, if not do B/A *100Originally Posted by SpoonMan22
Formula:
=IF(A2>B2, (B2/A2)*100, (A2/B2)*100)
If A is not larger than B then B is larger than A
It sounds like this will fix your problem
If A is larger than B, Then do A/B * 100, if not do B/A *100Formula:=IF(A2>B2, (B2/A2)*100, (A2/B2)*100)
If A is not larger than B then B is larger than A
It sounds like this will fix your problem
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks