View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Eduardo Eduardo is offline
external usenet poster
 
Posts: 2,276
Default If function with Calculation

=if(A11,A3/A,"Not Required")

If this was helpful please click yes, thanks

"WallyGathor" wrote:

Result I need to see in A2
If A1 1 then A3 / A1 but if A1<=1 "Not required"

I have tried a few things with the IF function without success.

Thank you for your help.
--
WG