You could also work the other way round;
=if(G6>0.75*G13,10,if(G6>0.5*G13,7.5,if(G6>0.25*G13,2.5,if(G6=G13,10))))
Hope this helps
Peter1999
You could also work the other way round;
=if(G6>0.75*G13,10,if(G6>0.5*G13,7.5,if(G6>0.25*G13,2.5,if(G6=G13,10))))
Hope this helps
Peter1999
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks