Thread: need help with if statement that calculate minimum figure
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Chip Pearson Chip Pearson is offline
external usenet poster
  
Posts: 7,247
Default need help with if statement that calculate minimum figure
Try something like

=IF(A2="yes",5,MIN(A4*A5,5))

Cordially,
Chip Pearson
Microsoft MVP
Excel Product Group
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)


On Sun, 16 Nov 2008 16:47:01 -0800, KateZed
wrote:

I am trying to calualate an if statement which if false returns a figure, but
i want that figure if under a certain amount to return a minimum figure.

Eg. If a2 = yes then return $5 if no or unknown then return A4*A5 but with a
minimum of $5
Reply With QuoteReply With Quote