Find attached file
Formula on F5 to give me positive only and formula G5 which
is =100%-J5 need without helper column
Find attached file
Formula on F5 to give me positive only and formula G5 which
is =100%-J5 need without helper column
No file attached!
Here is the file , sorry
In G5
=100%-IF(F5<0,F5*-1/E5,F5*1/E5)
Not sure what you mean by F5 postive only: if it is negative then ?????
In F5:
=ABS(D5-E5)
In G5:
=100%-(F5/E5)
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Wow AliGW , looks like you are more than just a forum moderator , I did not know about ABS function
Yes, I do help people occasionally, too ...
Glad to have helped.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks