LinkBack URL
About LinkBacks
Assuming reference cell is A1
=If(and(A1<=1,A1>.98),25,If(and(A1<.98,A1>=.95),10,0))
=if(and(A1>0,A1<.2),50,if(and(A1>.19,A1<.25),25,0))
Assuming reference cell is A1
=If(and(A1<=1,A1>.98),25,If(and(A1<.98,A1>=.95),10,0))
=if(and(A1>0,A1<.2),50,if(and(A1>.19,A1<.25),25,0))
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks