hey guys ,
please I have I formula stating
IF($A1=0;0;(100/$A1*B1)/100)
but it still showing me the word "VALUE"
How to not have it value word
please see attachment
hey guys ,
please I have I formula stating
IF($A1=0;0;(100/$A1*B1)/100)
but it still showing me the word "VALUE"
How to not have it value word
please see attachment
Try this........
=IF($A1="";"";(100/$A1*B1)/100)
Similarly in AC1 use the below formula.....
Please Login or Register to view this content.
Regards
sktneer
Treat people the way you want to be treated. Talk to people the way you want to be talked to.
Respect is earned NOT given.
If($a1="";0;(100/$a1*b1)/100)
Make Mom proud: Add to my reputation if I helped out!
Make the Moderators happy: Mark the Thread as Solved if your question was answered!
Change it to:
Formula:Please Login or Register to view this content.
let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source
If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE
Walking the tightrope between genius and eejit...
Hi Kuzna,
Pl refer attached corrected sheet. I have corrected formula as IF($A1="";"";(100/$A1*B1)/100)
Harshawardhan Shastri
Pl refer attached corrected file Formula corrected as IF($A1="";"";(100/$A1*B1)/100)
Harshawardhan Shastri
Hi,
Welcome to the Forum
In your formula column L & M are formatted as numbers. Hence the result shows as "value". Try this formula in column AC10 = IF(OR(L9="",M9=""),0,(100/$L9*$M9)/100)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks