=IF(N14="","",IF(J14="",M14/N14,((M14/N14)*385)/((J14*K14)*0.00785*1000))) is my current formula
I need to add a condition that if the resulting number is >or = 0.005 then it shows.
If the answer is <0.005 then I need it to say <0.005
Any help would be appreciated - Thanks
=if(if(n14="","",if(j14="",m14/n14,((m14/n14)*385)/((j14*k14)*0.00785*1000)))>.005,if(n14="","",if(j14="",m14/n14,((m14/n14)*385)/((j14*k14)*0.00785*1000))),"<0.005")
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
WANT TO SAY THANKS, HIT ADD REPUTATION (*) AT THE BOTTOM LEFT CORNER OF THE POST
More we learn about excel, more it shows us, how less we know about it.
for chemistry
https://www.youtube.com/c/chemistrybyshivaansh
Thank You so much
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks