View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Teri Teri is offline
external usenet poster
 
Posts: 77
Default Nested IF statement

What did I do wrong?

Here's the scenario and the formula I wrote: If the value of D48 X C13 is
less than B13, the value should be B13. If the Value of D48 X C13 is greater
than D13, the value should be D13. Otherwise the value should be D48 X C13.


=IF(AND(D48*C13<B13),B13,"(IF(AND(D48*C13D13,D13) OR(D48*C13)")