Hi All,
I have a problem with my excel sheet in round formula, in cell A1 =1 then the formula will round up the value like D7/D5 it should come like 2.67% if the value A1=2 then it will work the same way the result could be 3% (Rounded up)
=IF(A1=2,IFERROR(D7/D5,0),IFERROR(ROUND(D7/D5,0),0))
Help me to fix the issue. Thanks Raju
Try this formula. Make sure your cell is formatted as a percentage with the number of decimals you want to see.
Does that give you the results you're looking for?
Please Login or Register to view this content.
If someone helped achieve your solution, consider clicking "* Add Reputation" on their post.
If your question has been answered, mark the thread as [SOLVED] using the Thread Tools menu at the top of the thread.
[... deleted ... I did not see the inconsistency between your original formula (round if A1<>2) and your explanation (round if A1=2). Melvosh's response is good enough, although I would simplify the use of IFERROR]
Last edited by joeu2004; 05-14-2019 at 01:49 PM. Reason: improve readability, emphasis; errata: A1=1
One way
Format D9 to display 2 dec. places
Then D9=
Formula:
Please Login or Register to view this content.
Fianlly add add a conditional format to D9
Formula:Please Login or Register to view this content.
and format thh CF as % with zero dec. places.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks