View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Marcelo Marcelo is offline
external usenet poster
 
Posts: 1,047
Default If function with Calculation

=if(a11,a1/a3,"Not required")

--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"WallyGathor" escreveu:

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