Thread: Help with Formula
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Max Max is offline
external usenet poster
  
Posts: 9,221
Default Help with Formula
Maybe something along these lines:
=IF(AND(A80,A8<=4),(E8+2)*1.1,IF(AND(A84,A8<=10) ,(E8+4)*1.1,IF(AND(A810,A8<=25),(E8+6)*1.1,"")))
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"lizzyp" wrote:
I need to create a formula as follows: If A8<=4 then E8=sum(A8+2)*1.1 or if
A84<=10 then E8=sum(A8+4)*1.1 or if A810<=25 then E8=sum(A8+6)*1.1 etc.
Reply With QuoteReply With Quote