Davey72,
Easy enough to correct:
Alternate:![]()
=IF(A1=0,0,MAX(1,0.15*A1))
![]()
=(A1>0)*MAX(1,0.15*A1)
Davey72,
Easy enough to correct:
Alternate:![]()
=IF(A1=0,0,MAX(1,0.15*A1))
![]()
=(A1>0)*MAX(1,0.15*A1)
Hope that helps,
~tigeravatar
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
Thank you again Tigeravatar, that has worked perfectly..the way I was trying was =If(A1,6.66666,1,A1*0.15) kind of thing, and kept getting one, and couldn't figure out the zero value.
Best Regards
Davey
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks