Thread: Excell Formula help
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
joeu2004 joeu2004 is offline
external usenet poster
  
Posts: 2,059
Default Excell Formula help
"Jimog01" wrote:
I need to set up a formula that says:
A3 needs to be 30% of A2 unless B4 is less than 30% of A2,
Then A3 needs to be = to but not more than B4

=min(B4,A2*30%)
Reply With QuoteReply With Quote